Role : ETL (Informatica & SSIS) Engineer ( for Data Warehouse)
Responsibilities & Duties
Work with DW development team members and DBAs to deploy code changes to production environments.
Monitor, tune and maintain Data Warehouse and ETL jobs and environments, and implement ETL/DW system modifications..
Work with SMEs on data quality issues, troubleshoot/research user reported incidents
Work with DBAs and DW architects to optimize ETL jobs and DW queries
Analyze business process and data flow issues, help implement ETL design optimizations.
Evaluate DW /ETL tools and conduct POCs to identify feasibility of new solutions.
Provides DW technical support and guidance to analytics business users with the help of incident and problem management tools (ServiceNow) and processes.
Maintain and provide system configuration/ ETL application documentation for Audit compliance requirements.
Job Qualifications/Requirements
Required: 8+ years of experience as an IT Engineer or related occupation, implementing data management and analytics applications.
Required: 5+ years of experience in developing and supporting Informatica Power Center (ETL for Data Warehouse). SSIS/other ETL tool skills would be a plus.
Required: 5+ years of experience in writing T-SQL queries, stored procedures, and SQL Server databases.
Required: 2+ years of experience in scripting using Python and PowerShell
Required: Good understanding of the Data Warehouse concepts like dimensional modeling, dim tables, fact tables.
Required: Good experience in testing reports/BI applications and validating data for accuracy.
Preferred: 2+ years of experience in banking (retail banking, loan systems processes, and loan data) or a related field.
Preferred: Experience in gathering business and functional requirements and writing ETL technical specifications.
Preferred: Familiarity of Agile methodologies and tools like JIRA, Issue/Change management tools like ServiceNow.
Preferred: Good Experience with MS Office applications (Excel, Word, PowerPoint, Visio, SharePoint, Azure DevOps) in creating and communicating technical documents and managing source code.
Required: Excellent listening, communication, interpersonal, analytical and problem-solving skills.
Required: Ability to learn and apply new data management and analytics technologies without formal training.
Required: Ability to prioritize, meet deadlines and contribute both independently and as part of a team.
Required: Must enjoy working in a fast-paced teamwork environment.
Responsibilities & Duties
Work with DW development team members and DBAs to deploy code changes to production environments.
Monitor, tune and maintain Data Warehouse and ETL jobs and environments, and implement ETL/DW system modifications..
Work with SMEs on data quality issues, troubleshoot/research user reported incidents
Work with DBAs and DW architects to optimize ETL jobs and DW queries
Analyze business process and data flow issues, help implement ETL design optimizations.
Evaluate DW /ETL tools and conduct POCs to identify feasibility of new solutions.
Provides DW technical support and guidance to analytics business users with the help of incident and problem management tools (ServiceNow) and processes.
Maintain and provide system configuration/ ETL application documentation for Audit compliance requirements.
Job Qualifications/Requirements
Required: 8+ years of experience as an IT Engineer or related occupation, implementing data management and analytics applications.
Required: 5+ years of experience in developing and supporting Informatica Power Center (ETL for Data Warehouse). SSIS/other ETL tool skills would be a plus.
Required: 5+ years of experience in writing T-SQL queries, stored procedures, and SQL Server databases.
Required: 2+ years of experience in scripting using Python and PowerShell
Required: Good understanding of the Data Warehouse concepts like dimensional modeling, dim tables, fact tables.
Required: Good experience in testing reports/BI applications and validating data for accuracy.
Preferred: 2+ years of experience in banking (retail banking, loan systems processes, and loan data) or a related field.
Preferred: Experience in gathering business and functional requirements and writing ETL technical specifications.
Preferred: Familiarity of Agile methodologies and tools like JIRA, Issue/Change management tools like ServiceNow.
Preferred: Good Experience with MS Office applications (Excel, Word, PowerPoint, Visio, SharePoint, Azure DevOps) in creating and communicating technical documents and managing source code.
Required: Excellent listening, communication, interpersonal, analytical and problem-solving skills.
Required: Ability to learn and apply new data management and analytics technologies without formal training.
Required: Ability to prioritize, meet deadlines and contribute both independently and as part of a team.
Required: Must enjoy working in a fast-paced teamwork environment.