Job Description :
Position : ETL Developer with Informatica PowerCenter

Location: Farmington Hills, MI

Duration: 12 months

Mode of Interview: Phone Interview and In-person interviews only

It''s a contract for Independent consultant who can work on W2/1099/C2C (Own inc)

Job details :

The ETL Developer position focuses on ETL design, development and support. Responsible for ETL processes and tools as well as database loading and manipulation to ensure that the data needs are met throughout the course of the projects and production support. The developer will work to understand the business problems and opportunities in the context of the requirements and recommend solutions that enable the organization to achieve its goals. Additional responsibilities may include interpretation and transformation of information based on business requirements and conducting detailed research of vendor products and assists with general project management.

Design and implement Extract, Transformation and Load (ETL) processes, programs and scripts.
Assist with design and implementation of data warehouses, planning applications and reporting solutions.
Develop solutions to leverage ETL tools and suggest process improvements.
Provide ongoing maintenance and support of assigned ETL flows and their Client applications.
Collaborate with business users/developers to provide required data.
Research and provide alternatives and recommendations based on best practices and application functionality.
Understands the business processes, how the application supports the business processes and applies this knowledge to best solve problems
Gains necessary input/approval of requirements and design and participates in code reviews and may perform code review for others
Conduct root cause analysis and resolve production problems and data issues.
Validate the data in the database and also responsible for testing the routines developed.
Lead user sessions for requirements gathering and testing.
Assists in requirements gathering and creates system and user documentation
Create test plans, test cases, test scripts and performs functional testing
Assist users with problems and resolves issues independently.


Mandatory Skill set:
Informatica PowerCenter Administration

1. Informatica PowerCenter and its suite of tools upgrade and fresh installation
2. Hands-on admin knowledge of Informatica PowerExchange, Metadata Manager, Pro-Active Monitoring, Data Masking & Data Validation Option tools
3. Hands-on experience on EGO (Enterprise Grid Option), Oracle / UDB DB2 CDC
4. Usage and understandability of PowerCenter repository tables
5. Performance tuning, trouble shooting Informatica service logs, deployment groups etc
6. Architect, Design, Build, Test, Deploy and Operate ETL solutions using Informatica PowerCenter and PowerExchange
7. Informatica connectivity to advanced analytic tools (Hadoop, vertica etc)
8. Hands-on experience on Informatica Cloud configuration
             

Similar Jobs you may be interested in ..