Senior Technical Lead

Job description

Job Description: Ab Initio ETL Developer Experience 8–10 years of overall ETL/Data Engineering experience, with strong hands-on experience in Ab Initio development. Role Summary We are looking for an experienced Ab Initio ETL Developer / Data Engineer responsible for designing, developing, testing and supporting enterprise-scale ETL/data-processing solutions. The candidate should have strong hands-on experience with Ab Initio, SQL and Unix/Linux, along with a sound understanding of data warehousing and end-to-end ETL processes. Required Technical Skills Strong hands-on experience in Ab Initio ETL development. Experience developing and maintaining Ab Initio graphs and reusable ETL components. Strong working knowledge of Ab Initio components such as Reformat, Join, Rollup, Filter by Expression, Dedup, Sort and Scan. [Re: ANZ- D...Databases | Outlook] Experience with Ab Initio GDE and development of ETL transformations. [FW: Talent...experience | Outlook] Experience using Ab Initio EME / sandbox for version control, code promotion and impact analysis. [Re: ANZ- D...Databases | Outlook] Strong SQL skills and experience working with enterprise databases such as Oracle, Teradata, DB2 and Snowflake. These technologies appear across the relevant internal Ab Initio profiles. [Re: ANZ- D...Databases | Outlook], [FW: Talent...experience | Outlook] Good knowledge of Unix/Linux and Unix shell scripting. Experience in analysing business requirements and translating them into ETL designs and technical specifications. Experience with source-to-target data mapping, transformations, data cleansing and loading. Hands-on experience with unit testing, data validation and end-to-end testing of ETL solutions. Experience with batch/job scheduling and monitoring tools such as Autosys, Control-M, TWS or One Automation. [Re: ANZ- D...Databases | Outlook], [FW: Talent...experience | Outlook] Experience troubleshooting ETL failures, performing root-cause analysis and resolving production issues. Good understanding of Data Warehouse and ETL concepts. Key Responsibilities Analyse functional/business requirements and translate them into Ab Initio ETL solutions. Design, develop and enhance Ab Initio graphs for data extraction, transformation and loading. Develop mapping/transformation logic according to business and data requirements. Write and optimise complex SQL queries used within ETL processing. Perform code validation, unit testing and end-to-end data validation. Troubleshoot Ab Initio graphs, SQL and batch-processing issues. Conduct performance tuning of ETL jobs and SQL queries. Support code migration and deployment across environments. Monitor scheduled batch jobs and resolve job failures. Provide L2/L3 support, incident analysis and root-cause resolution where required. Collaborate with data engineers, testers, business analysts and other project stakeholders. The development, testing, migration, production-support and performance-tuning responsibilities above closely reflect the experience being sought/evaluated in your existing Ab Initio candidate pool. [Re: ANZ- D...Databases | Outlook], [FW: Talent...experience | Outlook] Preferred / Good-to-Have Skills Exposure to Snowflake or other cloud data platforms. Experience with large-volume enterprise data processing. Experience with data migration or modernisation programmes. Exposure to other ETL technologies such as IBM DataStage or Azure Data Factory. [FW: Talent...experience | Outlook] Knowledge of Agile delivery practices and tools such as Jira. Banking/financial-services domain experience would be advantageous for your ANZ context. Soft Skills Strong analytical and problem-solving capability. Good written and verbal communication. Ability to independently analyse complex data-processing issues. Strong collaboration with cross-functional and geographically distributed teams. Proactive approach to identifying data, performance and production risks. My recommendation for screening: treat Ab Key Responsibilities Job Description: Ab Initio ETL Developer Experience 8–10 years of overall ETL/Data Engineering experience, with strong hands-on experience in Ab Initio development. Role Summary We are looking for an experienced Ab Initio ETL Developer / Data Engineer responsible for designing, developing, testing and supporting enterprise-scale ETL/data-processing solutions. The candidate should have strong hands-on experience with Ab Initio, SQL and Unix/Linux, along with a sound understanding of data warehousing and end-to-end ETL processes. Required Technical Skills Strong hands-on experience in Ab Initio ETL development. Experience developing and maintaining Ab Initio graphs and reusable ETL components. Strong working knowledge of Ab Initio components such as Reformat, Join, Rollup, Filter by Expression, Dedup, Sort and Scan. [Re: ANZ- D...Databases | Outlook] Experience with Ab Initio GDE and development of ETL transformations. [FW: Talent...experience | Outlook] Experience using Ab Initio EME / sandbox for version control, code promotion and impact analysis. [Re: ANZ- D...Databases | Outlook] Strong SQL skills and experience working with enterprise databases such as Oracle, Teradata, DB2 and Snowflake. These technologies appear across the relevant internal Ab Initio profiles. [Re: ANZ- D...Databases | Outlook], [FW: Talent...experience | Outlook] Good knowledge of Unix/Linux and Unix shell scripting. Experience in analysing business requirements and translating them into ETL designs and technical specifications. Experience with source-to-target data mapping, transformations, data cleansing and loading. Hands-on experience with unit testing, data validation and end-to-end testing of ETL solutions. Experience with batch/job scheduling and monitoring tools such as Autosys, Control-M, TWS or One Automation. [Re: ANZ- D...Databases | Outlook], [FW: Talent...experience | Outlook] Experience troubleshooting ETL failures, performing root-cause analysis and resolving production issues. Good understanding of Data Warehouse and ETL concepts. Key Responsibilities Analyse functional/business requirements and translate them into Ab Initio ETL solutions. Design, develop and enhance Ab Initio graphs for data extraction, transformation and loading. Develop mapping/transformation logic according to business and data requirements. Write and optimise complex SQL queries used within ETL processing. Perform code validation, unit testing and end-to-end data validation. Troubleshoot Ab Initio graphs, SQL and batch-processing issues. Conduct performance tuning of ETL jobs and SQL queries. Support code migration and deployment across environments. Monitor scheduled batch jobs and resolve job failures. Provide L2/L3 support, incident analysis and root-cause resolution where required. Collaborate with data engineers, testers, business analysts and other project stakeholders. The development, testing, migration, production-support and performance-tuning responsibilities above closely reflect the experience being sought/evaluated in your existing Ab Initio candidate pool. [Re: ANZ- D...Databases | Outlook], [FW: Talent...experience | Outlook] Preferred / Good-to-Have Skills Exposure to Snowflake or other cloud data platforms. Experience with large-volume enterprise data processing. Experience with data migration or modernisation programmes. Exposure to other ETL technologies such as IBM DataStage or Azure Data Factory. [FW: Talent...experience | Outlook] Knowledge of Agile delivery practices and tools such as Jira. Banking/financial-services domain experience would be advantageous for your ANZ context. Soft Skills Strong analytical and problem-solving capability. Good written and verbal communication. Ability to independently analyse complex data-processing issues. Strong collaboration with cross-functional and geographically distributed teams. Proactive approach to identifying data, performance and production risks. My recommendation for screening: tr