Job Description
Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.
Design, develop, and support scalable IBM DataStage ETL solutions and enterprise data pipelines for mission-critical applications. Collaborate with business and technology teams to deliver high-quality, performant, and reliable data integration solutions aligned with enterprise architecture standards. The ideal candidate will have extensive experience working with multiple source and target systems including Oracle, DB2, Snowflake, flat files, cloud storage, structured, semi-structured, and unstructured data sources. The candidate should possess deep expertise in IBM DataStage, Snowflake, Unix Shell Scripting, and PL/SQL. This role involves building scalable data pipelines, optimizing data movement processes, supporting data warehouse, data lake, and Lakehouse platforms, and enabling enterprise analytics and reporting solutions.
Required Skills & Experience
- Strong hands-on experience with IBM DataStage 11.7 or above including Parallel Jobs, Sequencers, Parameter Sets, Job Monitoring, Administration, and Performance Tuning.
- Advanced SQL and PL/SQL development skills with strong experience in Oracle and DB2 environments.
- Design, develop, test, deploy, and support complex ETL/ELT solutions using DataStage and enterprise data pipelines.
- Develop reusable ETL frameworks using IBM DataStage, parameterized jobs, metadata-driven solutions, and automated data processing workflows.
- Analyze business and technical requirements and translate them into scalable ETL designs and data integration solutions.
- Implement data extraction, transformation, validation, cleansing, reconciliation, and loading processes using DataStage.
- Experience integrating data from Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage platforms using DataStage.
- Strong experience with Snowflake including Streams and Tasks, Dynamic Tables, Internal and External Stages, Secure Views, Data Sharing, and Query Performance Optimization.
- Experience designing, developing cloud-native data pipelines, and migrating data from on-premises systems to Snowflake.
- Strong Unix/Linux Shell Scripting skills for process automation, file handling, batch scheduling, operational support, and production troubleshooting.
- Experience creating high-performance batch, incremental, and CDC-based data pipelines for large-volume data processing.
- Strong understanding of ETL/ELT architecture, Data Warehousing, Dimensional Modeling, Data Lakes, and Data Lakehouse architectures.
- Experience with performance tuning, root cause analysis, production support, and incident management.
- Working knowledge of Git, CI/CD pipelines, Agile methodologies, and DevOps practices.
- 8-10 years engineering experience.
Education Requirements
A Bachelor’s degree in computer engineering, computer science or other related discipline is required.
Additional Information
After training, the candidate will be working independently and communicate/collaborate with stakeholders to understand business needs. The position is hybrid in Cincinnati, OH preferred, but open to remote candidates who will work eastern time.
Must Haves
- #1 requirement - IBM DataStage experience.
- #2 requirement - Snowflake skills.
- #3 requirement - Scripting experience (Unix).
- #4 requirement - Advanced SQL skills.
Nice to Haves
- CI/CD experience.
- Performance optimization in Snowflake.
- Previous payments experience.
Numbers & Facts
| Location | Cincinnati, OH |
| Industry | Staffing/Employment Agencies |
| Salary | $70–$80 Per Hour |
| Company Size | 500 to 999 employees |
| Website | http://www.ampcus.com |
About Company
Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.
Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.
We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted" that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.
Industry: Information Technology and Services
Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI
Skills
- Agile Programming Methodologiesunmatched
- Automationunmatched
- Business Analysisunmatched
- Business Servicesunmatched
- Candidate Sourcingunmatched
- Centers for Disease Control and Prevention (CDC)unmatched
- Cloud Computingunmatched
- Cloud Storageunmatched
- Computer Engineeringunmatched
- Computer Scienceunmatched
- Consultingunmatched
- Continuous Deployment/Deliveryunmatched
- Continuous Integrationunmatched
- Data Lakeunmatched
- Data Managementunmatched
- Data Migrationunmatched
- Data Modelingunmatched
- Data Processingunmatched
- Data Warehousingunmatched
- Database Extract Transform and Load (ETL)unmatched
- DevOpsunmatched
- Dimensional Modelingunmatched
- Engineeringunmatched
- Enterprise Architectureunmatched
- Gitunmatched
- IBM DB2unmatched
- IBM WebSphere DataStageunmatched
- Identify Issuesunmatched
- Incident Managementunmatched
- Information/Data Security (InfoSec)unmatched
- JSONunmatched
- Linux Operating Systemunmatched
- Metadataunmatched
- Microsoft SQL Serverunmatched
- Needs Assessmentunmatched
- Operational Supportunmatched
- Oracle Applicationsunmatched
- Oracle Databaseunmatched
- Oracle PL-SQLunmatched
- Performance Tuning/Optimizationunmatched
- Process Improvementunmatched
- Production Supportunmatched
- Query Optimizationunmatched
- Reconciliationunmatched
- Root Cause Analysisunmatched
- SQL (Structured Query Language)unmatched
- Scalable System Developmentunmatched
- Sequencersunmatched
- Snowflake Schemaunmatched
- Structured Dataunmatched
- Technical Deliveryunmatched
- Test Plan/Scheduleunmatched
- Unix Shell Programmingunmatched
- Unstructured Dataunmatched
- XML (EXtensible Markup Language)unmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder