Data Engineer-
Job Description
KEY SKILLS - Mainframe, Teradata Datastage
Mainframe and Teradata DataStage Associate
Summary:.
Minimum Degree Required: Bachelor's degree in computer science/IT or relevant field
Degree Preferred: Master's degree in computer science/IT or relevant field
Minimum Years of Experience: 6 - 8 year(s)
Certifications Required: NA
Required Knowledge/Skills: (character count limit 5000) PLEASE ONLY USE THIS FIELD IF THIS IS A MUST HAVE SKILL FOR APPLICANT
Job Summary
We are seeking a skilled and experienced IT professional to join our team as a Mainframe and Teradata DataStage Associate. The successful candidate will be responsible for developing, maintaining, and optimizing ETL processes using IBM DataStage, as well as managing and supporting data operations on Mainframe and Teradata platforms.
Key Responsibilities
• Design, develop, and implement ETL processes using IBM DataStage to support data integration and transformation requirements.
• Manage and maintain data on Mainframe and Teradata systems, ensuring data integrity and performance optimization.
• Collaborate with business analysts and stakeholders to understand data requirements and translate them into technical specifications.
• Troubleshoot and resolve issues related to ETL processes and data management on Mainframe and Teradata platforms.
• Monitor and tune the performance of ETL jobs and database queries to ensure optimal performance.
• Develop and maintain documentation related to ETL processes, data flows, and system configurations.
• Participate in code reviews and ensure adherence to best practices and coding standards.
• Provide support for data migration and integration projects, ensuring timely and accurate data delivery.
• Stay updated with the latest developments in Mainframe, Teradata, and DataStage technologies and recommend improvements.
Qualifications
Job Summary -
A career in our Managed Services team will provide you with an opportunity to collaborate with a wide array of teams to help our clients implement and operate new capabilities, achieve operational efficiencies, and harness the power of technology. Our Data, Testing & Analytics as a Service team brings a unique combination of industry expertise, technology, data management and managed services experience to create sustained outcomes for our clients and improve business performance. We empower companies to transform their approach to analytics and insights while building your skills in exciting new directions. Have a voice at our table to help design, build and operate the next generation of software and services that manage interactions across all aspects of the value chain.
Minimum Degree Required (BQ) :
Bachelor's degree
Degree Preferred
Required Field(s) of Study (BQ):
Preferred Field(s) Of Study
Computer and Information Science, Management Information Systems
Minimum Year(s) of Experience (BQ) : US
Certification(s) Preferred
Minimum of 1 year of experience
Preferred Skills (PQs)
Position Requirements:
Datasphere
Required Skills:
• More than 2 years of hands-on experience in SAP Datasphere / DWC at least 1 full life cycle project implementation.
• Work on development/maintenance of DWC Models, CDS Views, SQL Scripts SAC Stories
• Should have experience in building complex models in SAP Datasphere/ DWC
• Developing SAP Datasphere end-to-end Dataflows Design, build data flows, and develop chains to load and monitor Data Loading.
• Knowledge in setting up the connections to Datasphere and from Datasphere.
• Knowledge in handling the delta in Datasphere.
• Unit testing the dataflows and reconciling the data to Source Systems.
• Good exposure in troubleshooting data issues and provide workarounds in cases where there are product limitations.
• Good exposure with Datasphere security setup, currency conversion.
• Good knowledge in writing CDS Analytical Queries and S4HANA Embedded Analytics.
• Good exposure in performance tuning of the models in the datasphere.
• Good knowledge on Datasphere and Data Lake integration.
• Good Knowledge on using the Database explorer and SAP Hana Cockpit through Datasphere.
Nice To Have
• Good knowledge in either BW Modeling or HANA Modeling.
• BW/4HANA And/or Native HANA (or HANA Cloud) modeling, including SQL Scripting, Graphical View-Modelling, SDA extraction.
