Job Description :
DIBSYS Inc. is looking for a Lead Informatica ETL Developer / Architect. Must be a GC or USC.

Position: Lead Informatica ETL Developer / Architect
Location: Deerfield, IL
Duration: 3 Months (With Probable Extension)

What this role does:

- Architect, design, develop, performance tune and maintain ETL objects and scripts using Informatica Powercenter/Data Quality and advanced Transact SQL scripting.

- Provide Informatica subject matter expert (SME) for the Business Intelligence, Enterprise and IT teams in DentaQuest.

- Manage multiple technical project workflows and ensuring data quality from end-to-end.


- At least 7-10 years progressive work experience with minimum 5 years of hands-on design, workflow, development and performance tuning experience in data warehouse, SQL Server, and Informatica Powercenter/Data Quality.

- Architect and design Informatica objects and workflows .Assessing requirements and defining the strategy, technical architecture, implementation plan and delivery of data integration projects.

- Design, develop and maintain ETL data integration process with the Business Intelligence, Enterprise and IT team.

- Analyze and provide technical solution to business requested project from data integration and design perspective. Work with other departments on solidifying the solution from data and work flow perspective to ensure an integral end-to-end solution.

- Responsible for the ETL data integration process which is accomplished through the use of Informatica Powercenter and Data Quality, dynamic T-SQL, C#, ASP.NET, SSIS and Tivoli (TWS) Scheduler.

- Perform data object analysis by defining, analyzing, and validating data objects and relationship through the use of advanced T-SQL scripting and Informatica toolset.

- Implement data objects and integrating data shared across multiple source and target systems. Establish interfaces, developing and modifying functions, programs, routines, and stored procedures to extract, transform, and load data.

- Coordinating actions among developers, production control, DBA, infrastructure team and project vendor to implement the ETL scripts and objects.

- Validates ETL by developing and executing test plans and scenarios including data design and data quality. The toolsets include Informatica Powercenter and Informatica Data Quality (with data profiler and analyzer.

- Perform and maintain performance of data warehouse by identifying and resolving data conflicts, optimizing databases, networks and hardware.

- Incorporate metadata and data lineage to support BI enterprise data reporting.

- Improves data integration by designing and evaluating new data interchange formats. The environment is mainly consists of SQL Server database technologies, Informatica and supporting Business Intelligence toolsets such as Tableau and Microsoft SQL Server Reporting Services.

- Informatica Powercenter 9x, Informatica Data Quality 9x, Microsoft SQL Server, Business Intelligence Reporting, Requirements Analysis and Design, Data Conversion, Data Modeling with relational and dimensional structures.

- Advanced T-SQL scripting including dynamic and complex stored procedures experience.

- Subject matter expert experience with Informatica Powercenter and Informatica Data Quality including architecture, design, ETL trouble shooting and performance tuning.