Senior ELT Developer in Pittsburgh, PA, and client tech hubs

Senior ELT Developer in Pittsburgh, PA, and multiple client tech hubs | Pittsburgh, Pennsylvania, United States
Indotronix is seeking a Senior ELT Developer in Pittsburgh, PA, and multiple client tech hubs for our Direct client

Position Title:

Senior ELT Developer

Location:

Pittsburgh, PA, Cleveland, OH, Birmingham, AL, Dallas, TX, and Phoenix, AZ

Ability to work remote/hybrid: 3 days/week, but could go to 5 days a week if converted

Acceptable time zone(s): EST highly preferred

Days of the week: M-F

Working Hours (Flexible): 8 AM-5 PM

Duration:
Contract to hire

Roles and Responsibilities:

• This role requires senior-level enterprise engineering expertise, with strong hands-on experience in designing and developing scalable, high-performance ELT data pipelines using modern data integration platforms such as Informatica (Power Center / IDMC).

• The candidate must possess deep knowledge of data ingestion, transformation, and large-scale data processing, with a strong emphasis on ELT patterns in complex enterprise environments.

• The role demands proven experience in handling high-volume batch and near real-time data pipelines, including data staging, transformation pushdown, and optimization within database or cloud platforms.

• The individual should have a solid understanding of data warehousing concepts, data modeling, and reconciliation frameworks, ensuring data accuracy, consistency, and integrity across systems. In addition, the position requires strong experience in production support within mission-critical data platforms, including monitoring, troubleshooting, root cause analysis, and performance tuning to ensure the reliability and stability of data pipelines.

• The candidate should be comfortable working in distributed and event-driven ecosystems, with a focus on scalability, fault tolerance, and resiliency.

The role also requires:

• Hands-on experience in designing and implementing ELT pipelines, leveraging database or cloud processing capabilities

• Strong expertise in SQL and data transformation techniques, including performance tuning and query optimization

• Experience working with data platforms (RDBMS, cloud data warehouses, big data ecosystems)

• Familiarity with data orchestration tools (Airflow or similar) and scheduling frameworks

• Exposure to data quality validation, reconciliation, and audit frameworks

• Knowledge of Dev Ops practices, CI/CD pipelines, and version control for ETL/ELT deployments

• Ability to own end-to-end delivery, from design and development to deployment and production support

• Strong collaboration skills to work with business, data, and downstream systems teams to deliver scalable, enterprise-grade data solutions

Must Have Technical

Skills:

1. Designing and implementing ELT pipelines (Informatica)

2. SQL and data transformation techniques

3. data platforms (RDBMS, cloud data warehouses, big data ecosystems)

4. data orchestration tools (Airflow or similar) and scheduling frameworks

5. data quality validation, reconciliation, and audit frameworks

6. Dev Ops practices, CI/CD pipelines, and version control for ETL/ELT deployments

7. Ability to own end-to-end delivery, from design and development to deployment and production support

Soft Skills:

• Written and verbal communication skills

Education/

Certifications:

Bachelors minimum

Interview Process:

1st Round- w/HM 2nd Round as needed

Indotronix Commitment: A Safe and Inclusive Workplace" - Promoting a Culture of Inclusion, Respect, Equality, and Diversity:
Ensuring Safety and Non-Discrimination.

We actively strive to attract, retain, and empower a diverse range of talented individuals, recognizing that diverse perspectives and experiences enhance our collective performance.

Breaking Barriers:
Your Potential Knows No Limits. Embrace Your Potential, Apply Today!"

Indotronix Commitment to Pay Equity - At Indotronix, we are committed to Equal Employment Opportunity (EEO) and ensure pay equity across all job roles. We proudly champion equal pay for equal work, guaranteeing fair compensation for all employees based on their skills, experience, and contributions.

Celebrating & Honouring Veteran Contributions:
Approximately 13% of our workforce are veterans (nearly twice the national average). This achievement underscores our deep commitment in fostering Opportunities for success to Civilian Careers

Recognition - Indotronix has been recognized as one of the largest staffing companies in 2023 by Staffing Industry Analysts - a testament to our continued growth, commitment to excellence, and the trust our clients and candidates place in us.

Compliance Indotronix upholds good corporate citizenship by complying with all applicable laws, including taxation, equal employment opportunity, statutory benefits, and data reporting. In 2023, we hired over 1,200 U.S.

-based employees as consultants, contributing to workforce expansion and client service excellence.