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 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.
Design, develop and maintain ETL data integration process with the Business Intelligence and IT team.
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 export, transform, and load data;
Coordinating actions among developers, production control, DBA, infrastructure team and project vendor to implement out 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.
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 Cognos, Tableau and SQL Server Reporting Services
Candidate Skill Set
t least 8 years work experience with minimum 5 years of design and development experience in data warehouse, SQL Server, and Informatica Powercenter/Data Quality.
Advanced T-SQL scripting including dynamic and complex stored procedures experience.
Informatica Powercenter 9x and Informatica Data Quality 9x. Must have minimum 5 years of hands-on Informatica design, development and support.
Self-managing and ability to lead project solution end-to-end.
Business intelligence reporting experience using SQL Server Reporting Services, Cognos, Tableau and others.
High analytical skill and experience to support transitioning data architecture in a legacy and service oriented environment.
Experience in C#, SSIS, ASP.NET and Tivoli scheduler.
Good communication skill and ability to interact at all levels.