Job Description :
Job Title: ETL with MDM experience
Location: Atlanta, GA
Duration: 12 month + contract
Interview: Phone / Skype
Job Description:
The Data Integration Developer is responsible for data integration (ETL) development for data warehouse solutions that deliver diverse reporting and analytic capabilities to health and human services customers in the public and private sector. This role develops data integration programs that load, transform and extract data from the data warehouse, assures that architecture and development follow data warehouse best practices. This individual works with data warehouse architects, data architects, hardware/software engineers, DBAs, application vendors and managed services to ensure enterprise data warehouse solutions are reliable, scalable, flexible and low maintenance. The Data Integration Developer must demonstrate expertise in data warehouse concepts, practices, and procedures, has technical hands -on experience implementing data warehouse solutions, has strong communication skills and the ability to provide consultation to customers and collaborate internally on complex projects as a key contributor/specialist. This candidate should also be able to find creative solutions to complex and diverse business requirements.
Essential Responsibilities:
Review business and technical requirements and ensure the data integration platform meets requirements.
Apply industry best practices for ETL design and development.
Assists in design, development and implementation of end-to-end complex ETL system using Informatica tools
Plan and contribute to ETL development efforts for team utilizing Informatica tools.
Produce written deliverables for technical design, system testing and implementation activities.
Required Skills and Experience:
2+ years’ experience programming ETL programs using Informatica.
2+ years’ experience performing data analysis and profiling, and designing ETL systems/programs.
Expert SQL skills.
In-depth understanding of data integration best practices, leading industry applications and features such as master data management, entity resolution, data quality assessment, metadata management, and so on.
Understanding of data warehouse best practices.
Good communication skills.
Good interpersonal skills and the ability to collaborate with other technical teams, project management, client management and business analysts.
Health and human services experience.
Experience implementing ETL using Informatica software.
Experience implementing systems that utilize Oracle DBMS.
Bachelor''s degree AND 3+ years’ experience as integration programmer for data warehouse implementations
Top Skills:
Strong Master Data Management development and/or Meta Data management development
Informatica Development Experience
SQL Development Experience
Data Warehousing and Oracle DB experience
Thank you