Job Description
Role: ETL Developer / Senior Developer 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.
- Abili ty 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.
Salary Range - $100,000-$120,000 a year
Location
Pittsburgh, PA
Function
TECHNOLOGY
Role
Engineer
ID
439362
Skills
Data Integration
Salary Range
$100,000 - $120,000
Desired Candidate Profile
Qualifications BACHELOR OF COMPUTER SCIENCE
|