Senior ETL Informatica Developer

Senior ETL Informatica Developer

Job Summary:

Work with multiple data warehouse efforts with minimal supervision. Gather, analyze and understand business requirements. Develop, validate and implement efficient ETL code for data integration layers (data warehouse or data marts) to deliver multiple projects. Optimize the data environment for efficient data access and monitor performance of data warehouse ETL processes to ensure service level agreements with our users are met and implement tuning as needed. Manage the ETL processes and Informatica environments. Follow best practice, guidelines/procedures and naming conventions with enterprise-wide data collection and extraction. Work closely with database administrators and Unix engineers with database and infrastructure installations, designs and maintenance. Provide production support for all ETL processes. Plan and support lifecycle of data warehousing infrastructure components including database, operating system, ETL tools and various vendor products. Maintain and manage technical meta data and documentation for data warehousing and ETL processes. Serve as subject matter expert on assigned projects, production support areas and knowledge transfer to other team members.

Essential Job Functions:

1. Be responsible for translating business needs into technical solutions and specifications, and designing relational and/or dimensional models or flat files to meet project requirements. Perform source system data profiling including structure, data and relationship discovery; be responsible for understanding source system database structures and underlying data and knowledge transfer expertise to DW team members

2. Develop, manage and update conceptual, logical, and physical data models; evolve existing models to meet new and changing business requirements

3. Design, develop, maintain, test and modify ETL (Extraction, Transformation and Loading) processes with efficiency, best practices, naming conventions and ease of maintenance in mind; ensure quality and accuracy of the delivered data; ensure SLA (Service Level Agreement) with clients are met

4. Document ETL technical design process, high level and detailed meta data and reconciliation process; update DW production Informatica and Big Data job schedule document and document production issues and resolutions within On  Call Tips

5. Provide production support for all existing DW applications; respond to job failure related text page and/or emails in timely manner for critical DW applications

6. Scope, plan, prioritize and manage multiple tasks and projects; improve efficiency by working on other assigned tasks/projects while waiting for information on certain project(s)

7. Determine approaches to solutions, troubleshoot and maintain ETL processes with minimal guidance from team leads and supervisor

8. Follow project methodology of DW full development life cycles, prepare estimate and duration for development tasks and activities; provide bi-weekly project status to management on time; adhere to ETL development/migration standards by following ETL code review process on SharePoint and change control policies and procedures by submitting required documents in System Center for Service Manager (SCSM)


9. Plan and support lifecycle of DW infrastructure components including database, operating system, ETL tool and other vendor products with guidance from team leads and supervisor; participate in migrations and upgrades; monitor performance of ETL processes and implement tuning as needed with guidance from team leads

10. Maintain a positive work environment by acting and communicating in a manner which facilitates the success of business operations in order to  meet company demands and expectations