Job Summary
We are seeking a Sr. Developer with 6 to 8 years of experience to join our dynamic team. The ideal candidate will have extensive expertise in Ab Initio PL/SQL and Data Warehousing concepts. This role involves working in a hybrid model with a focus on day shifts. The candidate will play a crucial role in developing and maintaining ETL processes ensuring data integration and optimizing performance.
Responsibilities
Develop and maintain ETL processes using Ab Initio tools to ensure efficient data integration and transformation.Utilize Ab Initio Express>It and Ab Initio GDE to design and implement robust data workflows.Oversee the use of Ab Initio Metadata Hub for effective metadata management and data lineage tracking.Implement and manage external schedulers to automate and optimize ETL job executions.Write and optimize PL/SQL scripts to support data extraction transformation and loading processes.Apply deep understanding of Data Warehousing concepts to design and maintain data models and schemas.Ensure data quality and integrity through rigorous testing and validation of ETL processes.Collaborate with cross-functional teams to gather and analyze business requirements for data integration projects.Utilize SQL for querying and manipulating data within various databases.Leverage Unix Shell Scripting to automate routine tasks and enhance system performance.Monitor and troubleshoot ETL processes to resolve any issues promptly and ensure smooth operations.Provide technical guidance and support to junior developers and team members.Stay updated with the latest industry trends and best practices in ETL and data integration.
Qualifications
Possess a strong background in Ab Initio tools including Express>It GDE and Conduct>It.Demonstrate expertise in PL/SQL and SQL for data manipulation and transformation.Have a solid understanding of Data Warehousing concepts and best practices.Show proficiency in Unix Shell Scripting for automation and performance optimization.Exhibit experience with external schedulers and scheduling basics.Display knowledge of ETL processes and data integration techniques.Nice to have experience with Ab Initio Co>Operating System and Metadata Hub.Proven ability to work in a hybrid model and adapt to changing project requirements.Strong analytical and problem-solving skills to troubleshoot and resolve ETL issues.Excellent communication and collaboration skills to work effectively with cross-functional teams.Ability to mentor and guide junior developers in technical aspects.Commitment to staying updated with industry trends and continuous learning.
Certifications Required
Good to have Certified Ab Initio Developer Oracle PL/SQL Developer Certified Associate
