
GCP ETL Data Stage /Senior Software Engineer
- Hyderabad, Telangana Pune, Maharashtra
- Permanent
- Full-time
- Co-ordinations with stakeholders to ensure timely deliverables.
- Provide solution architecture support to projects where required ensuring that solution defined meets business needs, is aligned to functional and target architecture with any deviations approved.
- Analyze and propose plan to demise legacy systems.
- Lead a team of data engineers and assume responsibilities as Technical Lead for the assigned projects.
- Ensure full ownership and efficient management of the GDT IT services and products.
- Ensure that any new technology products are taken through the technology design governance process.
- Mentor and coach less experienced members of staff and promotes an understanding of the value of architecture and of use of technologies and standards in their domain across IT.
- Periodical monitor of team progress.
- Delivering optimum solution that meets client requirements.
- Inputs provided for Estimations, Monitoring & Co-ordinate team related activities.
- Involved in Designing, Development & Unit testing, Performance Testing the application
- Extensive ETL tool experience using IBM Infosphere/Websphere DataStage.
- Worked on DataStage tools like DataStage Designer, DataStage Director and DataStage Administrator.
- Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling.
- Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.
- Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter.
- Used Enterprise Edition/Parallel stages like Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL Coding.
- Familiar in using highly scalable parallel processing infrastructure using parallel jobs and multiple node configuration files.
- Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts and scheduling tools like Control M
- Experience in troubleshooting of jobs and addressing production issues like data issues, performance tuning and enhancements