Back to Job Search

Sr. ETL Informatica Developer

Posted 17 days ago

  • Expiry Date: 10 December 2021

​​​​​Job Description:

  • As a Senior ETL Developer in the Technical Operations organization, the ideal candidate will become part of a team responsible for the complete lifecycle and the management of Extract Transform Load (ETL) processes and database systems at client. Collaborating with business, development, and testing teams, facilitate accurate data reporting within company standards and maintain 24/7 system availability. Investigate and analyze issues, as well as research opportunities for improvement of processes. Provide expert system and technical advice and guidance to developers. Enable the use of data quality and accuracy as a strategic enabler.

Locations Atlanta, GA, OR Houston, TX.
Essential Duties and Responsibilities

Include the following. Other duties may be assigned:

Required skills and abilities:

  • Responsible for ETL development for assigned projects.

  • Responsible for timely project deliverables.

  • Responsible for writing ETL design documents.

  • Collaborates with development teams, business units to identify, define, develop and implement new data source feeds.

  • Monitors usage of the Data Warehouse to identify potential capacity overloads and bottlenecks.

  • Assists with the tuning of ETL processes and database performance.

  • Provides support for technical issues and ensuring system availability.

  • Remains current on Enterprise Data Warehousing technologies, testing industry trends and best practices

  • Provides guidance to more junior staff

  • Well-versed with project management methodology for SDLC.

  • Additional responsibilities may be assigned

Education and/or Experience:

  • Bachelor’s degree preferred.

  • A broad understanding of general business and management practices is preferred.

  • Complete understanding of all phases of the software development life cycle.

  • Expert Knowledge of application design principles, systems development, and analysis.

  • Complete understanding of relational database design and architecture

Technical Skills

Informatica

  • Advanced Informatica design and development skills using Informatica power center and power exchange. (10.1+ preferred)

  • 5+ years of experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager

  • Experience using parameter files, parameters/variables, and troubleshooting using advanced Informatica techniques like session partitioning, push down the optimization, etc.

Oracle

  • 5+ years of experience in PL/SQL

  • 5+ years of experience in writing advanced queries for analysis and troubleshooting as needed.

  • Must be well versed with database concepts like indexing, partitioning, performance tuning, explain plans, materialized views

Unix (Sun Solaris or Linux)

  • 3+ years of experience writing shell scripts.

  • Expertise in running jobs using various schedulers.

  • Must be well versed with all Unix commands needed for running ETL jobs as well as for troubleshooting source and target files. 

About ASK:ASK Consulting is an award-winning technology and professional services recruiting firm servicing Fortune 500 organizations nationally. With 5 nationwide offices, two global delivery centers, and employees in 42 states-ASK Consulting connects people with amazing opportunities

ASK Consulting is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all associates.