Please send rate, resume and contact information to Deepak.S@shstinc.com or call me if you have any questions.
Job: Informatica ETL Developer
Location: Detroit,MI
Duration:12+ Months contract
Informatica ETL Developer
The Informatica ETL Developer/Senior must have prior hands-on (MUST) experience delivering/leading successful data warehousing projects (Informatica specific) as well as broad background and experience with IT application development. This individual is responsible for working with other teams to deliver the artifacts and the code. This person must have strong professional consulting skills and the ability to communicate well at all levels of the organization
The Senior Developer should be able to perform the following with minimal supervision:
Understand Business Requirements and Conceptual Solution
Convert Business Requirements into Technical Requirements and Design
Create High Level Design
Create Detailed Technical Design
Create Informatica Mappings, Workflows and Sessions
Create Shell Scripts for automation
Understand the source systems and conduct the data profiling
Co-ordinate Data Modeling of Sources and Targets
Create Source to Target Mapping Specifications
Conduct Unit Testing and create Unit Testing Results Documents
Provide Support for QA/UA Testing
Migrate the code to Production
Provide warranty support
Assist and resolve production issues
The Senior Developer should have the following leadership skills:
Provide hands on technical leadership
Lead technical requirements, technical and data architectures for the data warehouse projects
Direct the discovery process
Provide knowledge guidance to Business Analysts and ETL Developers
Provide subject matter expertise and knowledge guidance to a team of analysts and ETL Developers
Lead the design and development of the ETL process, including data quality and testing
Follow the standards and processes defined
Contribute for process and performance improvements
Ensure compliance of meta data standards for the data warehouse
Top Three Skills/Experience
Informatica 9.x and above (MUST) - 5+ Years
Oracle 10g and above (MUST) - 5+ Years
Unix Shell Scripting - AIX or Linux (MUST) - 3+ Years
Required Skills/Experience
Informatica 9.x and above (MUST)
Oracle 10g and above (MUST)
Unix Shell Scripting - AIX or Linux (MUST)
Experience in any of Scheduling Tools - Tivoli, Autosys, Ctrl-M (2+ Years)
More than 5 years experience as ETL Developer using Informatica and Oracle 10g/11g to implement data warehousing projects
More than 2 years of experience in leading/designing Informatica projects
Excellent understanding of data warehousing concepts.
Candidate should be able to clearly communicate fundamental concepts during the interview and demonstrate previous experience in all aspects.
MUST HAVE strong SQL skills in Oracle 10g/11g
Experience in Business Intelligence reporting tools like Cognos and Business Objects
Experience in Oracle database programming using Partitioning, Materialized View and OLAP
Experience in tuning Oracle queries/processes and performance management tools
Experience in scheduling tools like Tivoli, Autosys
Strong data modeling skills (normalized and multidimensional)
Strong business and communication skills
Preferred Skills/Experience
Knowledge of Health Care Insurance Payer Data Warehousing Preferred
Deepak Rana
Technical Manager
E-mail : Deepak.s@shstinc.com
Direct Line : 412-450-1316 Ext 114
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To post to this group, send email to sureshotjobs@googlegroups.com.
Visit this group at http://groups.google.com/group/sureshotjobs.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment