Informatica (ETL) Developer/ Informatica (ETL) Lead, Long-term Contract

0 views
Skip to first unread message

Shashi M

unread,
Feb 20, 2019, 4:51:34 PM2/20/19
to sha...@perksys.com

Informatica (ETL) Developer

Location: Westerville, OH

Duration : Long-term Contract

 

DESIRED SKILLS AND EXPERIENCE:

Minimum of 5-10 years of Software experience with 5+ on Data Warehousing

3+ years of Informatica(9.6+) development with Power Centre and Power Exchange

 

Mandatory Technical Skills

-  Sound Knowledge of Data warehousing concepts, terminology and Architecture.

-  Excellent ETL (Including XML) Design and development Experience

-  Good understanding of the commonly used transformations like Source qualifier, joiners, union, aggregator,    

    sorter, expressions, transaction control, xml transformation, lookups etc

 

Ability to understand mapping document and translate the same to Informatica Mapping

-  Ability to create CDC, SCD, Fact load and complex mappings with Informatica

-  Sound concepts of RDBMS with hands on with performance tuning of ETL / DB / SQL Queries

-  Good knowledge of UNIX with ability to create Unix/Linux shell scripts to run ETL jobs and trap any failures.

-  Skill in gathering and documenting user requirements and writing technical specifications

-  Good knowledge of SDLC for projects using DW concepts and Client/Server technologies.

-  Create detail mapping documents, module spec and unit test cases

-  Hand on with informatica development, Configuration and Performance tuning

 

Interpersonal Skills

-  Well developed analytical & problem-solving skills

-  Strong oral and written communication skills

-  Excellent team player, able to work with virtual teams

-  Ability to learn quickly in a dynamic start-up environment

-  Able to talk to client directly and report to client/onsite

-  Flexibility to work on different Shifts and Stretch

-  Flexible to travel and relocate in India and Abroad

 

Good to have:

-       Working knowledge of Peoplesoft HCM connectors

-       Working knowledge of Hadoop Connector to load data to Big data

-       Olap Tools

-       Data Modeling

-       Worked on HR related data with Any ERP particularly PeopleSoft

-       Java Coding skills

-       Agile Development Experience

-       Worked on cloud environment

 

 

Informatica (ETL) Lead

Location: Newark, DE

Duration : Long-term Contract

 

DESIRED SKILLS AND EXPERIENCE:

Minimum of 10-15 years of Software experience with 10+ on Data Warehousing

5+ years of Informatica(9.6+) development with Power Centre and Power Exchange

 

Mandatory Technical Skills

-  Sound Knowledge of Data warehousing concepts, terminology and Architecture.

-  Experience in using informatica PeopleSoft connectors, Data Structures

-  Experience in using informatica with Big data connectors for data load to Hadoop

-  Excellent ETL (Including XML) Design and development Experience

-  Good understanding of the commonly used transformations like Source qualifier, joiners, union, aggregator,    

    sorter, expressions, transaction control, xml transformation, lookups etc

 

Ability to understand mapping document and translate the same to Informatica Mapping

-  Ability to create CDC, SCD, Fact load and complex mappings with Informatica

-  Sound concepts of RDBMS with hands on with performance tuning of ETL / DB / SQL Queries

-  Good knowledge of UNIX with ability to create Unix/Linux shell scripts to run ETL jobs and trap any failures.

-  Skill in gathering and documenting user requirements and writing technical specifications

-  Good knowledge of SDLC for projects using DW concepts and Client/Server technologies.

-  Create detail mapping documents, module spec and unit test cases

-  Hand on with informatica development, configuration and Performance tuning

 

Interpersonal Skills

-  Well developed analytical & problem-solving skills

-  Strong oral and written communication skills

-  Excellent leadership skills with ability lead and guide and groom the team

-  Excellent team player, able to work with virtual teams

-  Ability to learn quickly in a dynamic start-up environment

-  Able to talk to client directly and report to client/onsite

-  Flexibility to work on different Shifts and Stretch

-  Flexible to travel and relocate in India and Abroad

 

Good to have:

-       Olap Tools

-       Data Modeling

-       Worked on HR related data with Any ERP particularly PeopleSoft

-       Java Coding skills

-       Worked on Informatica on the cloud environment

 

 

 

 

 

Please share your updated resume at sha...@perksys.com

 

Many Thanks,

Shashi

Perk Systems Inc

Email: sha...@perksys.com

Reply all
Reply to author
Forward
0 new messages