We are seeking a skilled professional to join our team as an ETL Developer. In this role, you will be responsible for workload prioritization, resource management, and delivering ETL applications using Teradata, DataStage, Oracle, and Linux Scripting. You will also be involved in data modeling, data integration solutions, and performance optimization. The ideal candidate will have experience in Teradata, DataStage, Oracle, Linux Scripting, and data modeling. Strong communication skills and the ability to work in a global team are essential.
Job Description
Mandatory Skills : Teradata , DataStage Linux Scripting , Data Modelling (Erwin /Power Designer)
Desired Skills : Oracle , Python scripting , Autosys
Responsibilities :
- Responsible for workload prioritization and management of resources, both on service requests and small projects.
- Maintaining and Providing the Status to mgmt. and Onshore leads
- Expert in Architecture, design, develop and deliver ETL applications using DataStage, Teradata, Oracle and Linux Scripting
- Creating and updating data models, defining information requirements for small to medium size projects
- Creating ETL specifications / source to target mapping based on project requirements,
- Generate data definition language DDL used to create the database schemas and tables
- Hands on code development, source code control, specification writing and production implementation
- Participate in requirements gathering sessions, guide the design & development by providing insights of data sources and peer reviews
- Participate and guide data integration solutions that are needed to fill the data gaps Debug data quality issues by analysing the upstream sources and provide guidance to data integration team resolutions
- Closely work with DBAs to fix performance bottlenecks
- Proefficiency in Data Modelling (Erwin /Power Designer)
- Participate in technology governance groups that defines policies, best practices and make design decisions in on-going projects
- Mentor junior developers regarding best practices and technology stacks used to build the application
- Work closely with Operations, Teradata administration teams for code migrations and production support
- Provide Resource and effort estimates for EDW - ETL & Extract projects
- Experience working as part of a global development team
- Conduct code reviews of ETL development
- Ready to work in shift timings ( 11am - 9 Pm) weekdays and also support oncall per ROTA (weekdays and Weekends)