Data Engineer

Capgemini; Cincinnati (OH); On-site; USD 58,000 - 91,000; Full time

Job summary

Capgemini in Cincinnati is seeking a DataStage Senior Developer with 5+ years of experience to design, develop, and support enterprise ETL solutions using IBM InfoSphere DataStage.

The role partners with business stakeholders and data architects to optimize data warehouses and ensure high-quality data solutions. Strong SQL, Python, and data warehousing skills are essential for success.

Qualifications

• Bachelor's degree or higher in a related field.
• Minimum 5+ years hands-on IBM InfoSphere DataStage development.

Responsibilities

• Design, develop, test, and deploy ETL processes using IBM InfoSphere DataStage.
• Analyze requirements and translate into ETL solutions.
• Maintain DataStage jobs, sequences, and reusable components.
• ETL from multiple sources to data warehouses/data marts.

Skills

IBM DataStage

ETL Development

SQL

Data Warehousing

Performance Tuning

Python

Education

Bachelor's degree in CS/IT/Engineering

Tools

DataStage Designer

DataStage Director

DataStage Administrator

Control-M

Autosys

Job description

We are seeking a highly skilled DataStage Senior Developer with 5+ years of experience in designing, developing, and supporting enterprise data integration and ETL solutions using IBM InfoSphere DataStage. The ideal candidate will have strong expertise in data warehousing, ETL development, database technologies, and performance optimization. The individual will work closely with business stakeholders, data architects, and development teams to deliver high-quality data solutions.

Key Responsibilities

• Design, develop, test, and deploy ETL processes using IBM InfoSphere DataStage.
• Analyze business requirements and translate them into technical ETL solutions.
• Develop and maintain DataStage jobs, sequences, shared containers, and reusable components.
• Perform data extraction, transformation, and loading (ETL) from multiple source systems to data warehouses and data marts.
• Optimize DataStage jobs for performance, scalability, and reliability.
• Monitor ETL workflows and troubleshoot production issues.
• Conduct data validation, reconciliation, and quality checks.
• Work with database teams to design and implement efficient data models.
• Create and maintain technical documentation, mapping documents, and deployment procedures.
• Participate in code reviews and ensure adherence to development standards and best practices.
• Support production releases, incident management, and root cause analysis.
• Collaborate with cross-functional teams including Business Analysts, Architects, QA teams, and Support teams.

Required Technical Skills

• ETL & Data Integration:
• IBM InfoSphere DataStage (PX/Parallel Jobs, Server Jobs, Sequences)
• DataStage Designer, Director, Administrator
• Job sequencing and workflow management
• DataStage performance tuning and optimization
• Databases:
• Oracle
• SQL Server
• Snowflake (preferred)
• Programming & Scripting:
• SQL and Advanced SQL Queries
• Python (preferred)
• Data Warehousing:
• Data Warehouse concepts
• Dimensional Modeling (Star Schema, Snowflake Schema)
• Fact and Dimension tables
• Data Migration and Data Conversion

Tools & Technologies

• Control-M or Autosys
• Git, SVN, or other version control tools
• JIRA or Agile project management tools

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
• 5+ years of hands-on experience with IBM InfoSphere DataStage development.
• Strong knowledge of ETL methodologies and data integration best practices.
• Experience working with large-volume data processing environments.
• Strong SQL and database development skills.
• Experience in production support and issue resolution.
• Understanding of Software Development Life Cycle (SDLC) and Agile methodologies.

Preferred Qualifications

• IBM DataStage Certification.
• Experience with Cloud Data Platforms such as AWS, Azure, or Snowflake.
• Knowledge of Data Governance and Data Quality frameworks.
• Experience with Big Data technologies (Hadoop, Spark) is a plus.
• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management skills.
• Ability to work independently and lead ETL development activities.
• Attention to detail and commitment to data quality.
• Strong teamwork and collaboration abilities.

Nice-to-Have Skills

• Snowflake Data Warehouse
• Informatica or Talend ETL tools
• AWS
• Databricks
• Kafka or real-time data integration technologies

The pay range that the employer in good faith reasonably expects to pay for this position is $42.18/hour - $65.91/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

Tundra Technical Solutions is among North America's leading providers of Staffing and Consulting Services. Our success and our clients' success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.