29 days old

Data Engineer: Data Integration

Amritsar, PB 143001
  • Job Code

At IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you've never thought possible. Are you ready to lead in this new era of technology and solve some of the world's most challenging problems? If so, lets talk.

Your Role and Responsibilities
  1. Develop and deploy the extraction, transformation, and loading routine for the data warehouse environment by sourcing the data from the operational systems, applying the business transformation rules, and loading it to the data warehouse and data mart environments
  2. Analyze and develop strategies for data acquisitions, archives, recovery, and implementation of the ETL repository and load jobs
  3. Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the data warehouse
  4. Implement and execute strategy for change data capture
  5. Create testing methodology and criteria
  6. Perform detailed data analysis including data quality and consistency by monitoring production data
  7. Investigate, analyze, document and correct reported defects
  8. Develop specifications for data cleansing, data scrubbing, ETL and data migration processes
  9. Develop and maintain standards, common processes and best practices for ETL architecture including batch jobs auditing and balancing
  10. Design and implements automation of data loading and cleansing processes
  11. Modify ETL processes to accommodate source system changes with new business user requirements
  12. Populate the data warehouse using data modeling techniques for target structures such as star schemas, snowflake schemas, and highly normalized data models
  13. Interpret written business requirements and transform into technical specifications
  14. Create and maintain technical specification documentation
  15. Perform data integrations through complete SDLC including design, build, test and deploy activities
  16. Responsible for performing optimizations to fulfill key performance requirements for handling large volumes of data

Required Technical and Professional Expertise

  1. Preferably 3+ years of experience in SQL query development.
  2. Full understanding of the processes of data quality, data cleansing and data transformation
  3. Full understanding of Extract Transform Load (ETL) concepts and technologies
  4. Knowledge of Data Warehousing tools, patterns and processes
  5. Experience Database design and well versed with SQL best practices
  6. Experience working in a team-oriented and collaborative environment
  7. Excellent Interpersonal, Written, and Verbal Communication Skills
  8. Excellent Technical Documentation Skills
  9. Excellent knowledge of data warehouse concepts, technologies, and best business practices to include data sourcing, data transformation, data loading, data cleansing, data integrity checking, and end-user tools
  10. Ability to present and deliver analytical/conceptual ideas in a professional manner

Technology & Domain

  1. DB2 Data Warehouse (DB2DW)
  2. Datastage & Open Source ETL tools

Preferred Technical and Professional Expertise

About Business Unit
IBM Services is a team of business, strategy and technology consultants that design, build, and run foundational systems and services that is the backbone of the world's economy. IBM Services partners with the world's leading companies in over 170 countries to build smarter businesses by reimagining and reinventing through technology, with its outcome-focused methodologies, industry-leading portfolio and world class research and operations expertise leading to results-driven innovation and enduring excellence.

Your Life @ IBM
What matters to you when youre looking for your next career challenge?

Maybe you want to get involved in work that really changes the world? What about somewhere with incredible and diverse career and development opportunities where you can truly discover your passion? Are you looking for a culture of openness, collaboration and trust where everyone has a voice? What about all of these? If so, then IBM could be your next career challenge. Join us, not to do something better, but to attempt things you never thought possible.

Impact. Inclusion. Infinite Experiences. Do your best work ever.

About IBM
IBMs greatest invention is the IBMer. We believe that progress is made through progressive thinking, progressive leadership, progressive policy and progressive action. IBMers believe that the application of intelligence, reason and science can improve business, society and the human condition. Restlessly reinventing since 1911, we are the largest technology and consulting employer in the world, with more than 380,000 IBMers serving clients in 170 countries.

Location Statement
For additional information about location requirements, please discuss with the recruiter following submission of your application.

Being You @ IBM
IBM is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.



  • Computers Software and Hardware
Posted: 2019-09-16 Expires: 2019-10-16

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Engineer: Data Integration

Amritsar, PB 143001

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast