Senior ETL Informatica Developer

Pyramid Consulting Inc.
McLean, United States of America
2 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

McLean, United States of America

Tech stack

Query Performance
Agile Methodologies
Amazon Web Services (AWS)
Unit Testing
CA Workload Automation Ae
IBM Rational ClearCase
ETL
Github
Revision Control Systems
Shell
E2e Testing
SQL Databases
System Testing
Informatica Powercenter
Snowflake
Integration Tests
Vertica
Pyramid
Software Version Control

Job description

Immediate need for a talented Senior ETL Informatica Developer with experience in the Financial and Banking Industry. This is a 6+ Months Contract opportunity with long-term potential and is located in Mclean, VA. Please review the job description below., * Support migration of Informatica Power Center ETLs connections from Vertica to Snowflake.

  • Support and integrate existing Informatica Power Center ETL's with Snowflake.

  • Support and develop new ETL component integration with Snowflake and make recommendations for functions that result in a more cost- effective product delivery.

  • Work with initiative leads, business areas, technical leads, architects, subject matter experts, developers, technical support groups and test teams to deliver value to the business;

  • Support development and deliver PowerCenter and IICS components as specified in the design, functional and non-functional requirements

  • Perform unit testing of PowerCenter and IICS components and document te

  • st results when needed;

  • Correct testing defects and support all testing, including but not limited to: Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, andPerformance Testing.

  • Perform troubleshooting on Informatica PowerCenter and IICS components and work with Informatica GCS where needed;

  • Identify application bottlenecks and opportunities to optimize performance;

  • Provide resolution to an extensive range of complicated PowerCenter and IICS related problems, proactively and as issues surface;

  • Perform code version control activities via GitHub.

Requirements

  • College Degree or equivalent experience; advanced studies/degree preferred;
  • Minimum six (6) years overall current and hands-on development/integration/administration experience with Informatica Power Center and IICS.
  • Minimum five (5) years of current and hands-on experience with complex SQL and high-volume Relational databases and SQL Query performance tuning;
  • Minimum two (2) years of current and hands-on Amazon Web Services (AWS);
  • Minimum two (2) years of current and hands-on UNIX shell scripting experience;
  • Minimum two (2) years of current and hands-on Autosys experience;
  • Minimum two (2) years of current and hands-on experience with code management tools such as GitHub or ClearCase;
  • Agile team exposure preferred
  • Self-starter that takes initiative to fill in gaps where needed

About the company

Our client is a leading Financial and Banking Industry and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.

Apply for this position