Job Summary
Role : ETL Developer
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
2. Design, develop, and optimize etl processes to extract, transform, and load data efficiently.
3. Collaborate with cross functional teams to gather business requirements and translate them into technical solutions.
4. Provide technical guidance and mentorship to junior team members.
5. Perform code reviews, identify areas for improvement, and ensure best practices are followed.
6. Troubleshoot and resolve complex technical issues related to data processing and integration.
7. Monitor system performance and ensure data accuracy and integrity.
8. Stay updated with industry trends and technologies to recommend innovative solutions for continuous improvement.
Skill Requirements
2. Strong expertise in sql for data manipulation and querying.
3. In-depth knowledge of oracle pl/sql for database development and management.
4. Proficient in unix shell scripting for automation and scheduling tasks.
5. Ability to work collaboratively in a team environment and lead technical discussions.
6. Strong problem-solving skills and attention to detail with excellent communication and interpersonal skills
7. Experience in performance tuning and optimization of etl processes.
8. Knowledge of data warehouse concepts and methodologies.
9. Knowledge of using azure devops for build and deploy
10. Familiarity with creating physical data model based on the data model logic