Job Description :
Client is hiring a Data Integration Consultant to manage data analysis and data integration of different systems and to build extensible data acquisition and integration solutions to meet the functional and non-functional requirements of the business. The Data Integration Consultant will design, structure, and develop Informatica data warehouse program logic. The Developer is responsible for the programs required to extract, transform, clean, and move data and metadata so they can be loaded into a data warehouse, data mart, or operational data store. In addition, he/she will lead the work of other ETL Developers and work closely with Data Analyst and Data Modelers to develop enterprise data integration solutions that promote reusability and standardization.

Essential Job Functions
Design, code, and test major features, as well as work jointly with other team members to provide complex software enhancements for databases
Collaborate with functional team and other team leads to create integration solutions
Apply generally accepted programming standards and techniques to assure efficient program logic and data manipulation
Ensure design structure, and content meet performance guidelines; assist with test planning and testing
Develop detailed documentation including functional and technical design documents, test cases, support documentation, migration and installation steps, release notes, mapping documents etc.
Provide high-level analysis and design reviews to solve conceptual problems and avoid duplication of efforts within the development group

Skills and Qualifications Required:
5+ years of experience as an ETL Developer
Extensive experience with SQL with relational databases (SQL Server, DB2)
Experience writing stored procedures
Experience with relational and dimensional data modeling
Experience building and operating a data warehouse
Knowledge of Data Profiling and Data Quality concepts and techniques
Critical thinker with excellent analytical and problem-solving skills
Advanced knowledge of industry standards/best practices surrounding all aspects of the Software Development Life Cycle