Bangalore, Karnataka
Job Summary
Job Description:
Design, develop and deliver data integration/data extraction solutions using IBM DataStage, Oracle, SQL Server and Data Warehouse platforms
Debug data quality issues by analyzing the up stream sources and provide guidance to data integration team resolutions.
Work closely with support teams for code migrations and production support - Have a hands-on approach to solving problems; when required, be able to lead-by-example-type of person in developing snippets of the code that team can use and follow.
Have deep knowledge of data architectures, ODSs, Data warehouses and methodologies.
Maintain and constantly refine the Production failures and escalations; be able to capture, articulate and create knowledge base of Production ETL functioning and potential points of failures.
Have a thorough knowledge of working in Agile environments and adopt to multiple itineraries running in concurrency.
Directs system enhancements and projects through the SDLC life cycle, Agile methodologies, defining project objectives, aligning project resources to achieve goals and ensuring established timelines are met.
Drive the requirement gathering process for all system enhancements initiatives, establishes and enforces best practices for analysis.
Maintains an in-depth knowledge of business operations and understands the technical scope and objectives of each project.
Requirements:
6-9 years of experience as an ETL developer.
Mandatory: ETL, DataStage 8.x, DataStage 9.x, Unix, Datawarehouse, SQL, DBT or Airflow
Senior level knowledge in Core Competencies: Hands-on development on Data stage as an ETL tool, ETL architecture, Datawarehouse development knowledge, Systems
Analysis, Project Management, Information Technology/Software Development, Basic Technical Writing, Process Flow Documentation, Strong Communication Skills
Knowledge of Finance industry – especially Banking industry is a plus.
Strong track record of interviewing business partners, setting and managing expectations in relation to deliverables and requirements
Solid understanding of Agile development methodologies and software project life cycle and associated methodologies.
Experience with standard systems analysis tools and procedures.
Excellent problem solving skills and analytical skills.
Excellent verbal and written communication skills with the ability to establish deep understanding of client's business issues.
Key Responsibilities
1. Design, develop, and implement data integration solutions using ibm infosphere datastage suite.
2. Write and optimize complex sql queries for data retrieval and manipulation.
3. Develop and maintain oracle pl/sql procedures, functions, and packages for data processing.
4. Create and maintain unix shell scripts for automation and scheduling of data workflows.
5. Collaborate with stakeholders to gather requirements and provide technical recommendations for data integration projects.
6. Perform troubleshooting, debugging, and performance tuning of data integration jobs.
7. Ensure data quality, integrity, and security in all data processing activities.
Skill Requirements
1. Proficiency in ibm infosphere datastage suite for etl processes.
2. Strong command over sql for querying and managing relational databases.
3. Experience in developing and optimizing oracle pl/sql procedures.
4. Knowledge of unix shell scripting for automating data workflows.
5. Strong analytical and problem-solving skills.
6. Excellent communication and interpersonal abilities to work effectively in a team.
7. Ability to prioritize tasks and manage time efficiently.
8. Attention to detail and commitment to delivering high-quality work.
9. Strong experience in using azure devops for build and deploy
10. Familiarity with creating physical data model based on the data model logic
#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-
