← Back to jobs

Avance Consulting Logo
ETL Developer / Senior Developer (Informatica)

Avance Consulting

 

Pittsburgh, PA, USA

Posted On: Just posted
Experience: 10+ years
Availability: Onsite
Openings: 1
Category: ETL Developer
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

Must-Have Skills:

  • ETL / Data Integration: Strong hands-on experience designing, developing, testing, and supporting enterprise-scale ETL/ELT pipelines.
  • ETL Tools: Strong experience with Informatica PowerCenter / IICS or equivalent enterprise ETL platforms such as IBM DataStage, Talend, or SSIS.
  • SQL: Advanced SQL development including complex queries, joins, CTEs, stored procedures, query optimization and performance tuning.
  • Databases: Strong experience with Oracle, SQL Server, PostgreSQL or similar relational databases.
  • Data Warehousing: Strong understanding of data warehouse concepts, dimensional modeling, Star/Snowflake schemas, fact/dimension tables and SCDs.
  • Data Pipelines: Experience building high-volume batch and incremental data pipelines, including CDC and data validation.
  • Performance: ETL job optimization, troubleshooting, root-cause analysis and database/query performance tuning.
  • Scripting: Working knowledge of Unix/Linux Shell scripting and/or Python for automation and data processing.
  • Scheduling: Experience with enterprise schedulers such as Control-M, Autosys or equivalent.
  • Version Control / CI-CD: Experience with Git, Jenkins, Azure DevOps or comparable CI/CD tooling.
  • Cloud / Modern Data: Exposure to AWS, Azure or Snowflake and cloud-based data integration patterns preferred.

Roles & Responsibilities:

  • Design, develop and maintain scalable ETL/ELT solutions to ingest, transform and integrate data across multiple source and target systems.
  • Translate complex business and data requirements into technical ETL designs, mappings, source-to-target specifications and transformation rules.
  • Develop complex SQL queries, stored procedures and database objects supporting data integration and warehouse workloads.
  • Build and optimize batch, incremental and CDC-based data pipelines while ensuring accuracy, completeness and performance.
  • Perform ETL and SQL performance tuning, identify bottlenecks and resolve production issues through structured root-cause analysis.
  • Implement data validation, reconciliation, exception handling, logging, monitoring and restart/recovery mechanisms.
  • Work closely with data architects, business analysts, database administrators, QA teams and upstream/downstream application teams.
  • Participate in code reviews, technical design reviews, release planning and production deployments.
  • Support production ETL workloads, including troubleshooting failed jobs, data discrepancies and performance issues.
  • Drive modernization opportunities, including migration of legacy ETL workloads toward cloud and modern data platforms.
  • Mentor junior developers and establish reusable patterns and development standards for the ETL team.

Generic Managerial Skills:

  • Ability to lead technical design discussions and independently own complex data integration components.
  • Strong stakeholder communication with business, architecture and technology teams.
  • Ability to mentor and guide junior/mid-level developers and perform code/design reviews.
  • Strong problem-solving, analytical and root-cause analysis capabilities.
  • Ability to estimate development effort and support sprint/release planning.
  • Ability to manage priorities across development, enhancements, defects and production support.
  • Experience working in Agile/Scrum delivery environments.
  • Ability to identify technical risks, dependencies and performance issues and proactively drive them to closure.
  • Strong documentation and communication skills, including technical specifications and knowledge-transfer documentation

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs