About this role
<p style="text-align:center"><span style="font-size:14.0pt;line-height:115%;font-family:'GFT Corporate SemiBold';color:#001326">Job description</span><span style="font-size:14.0pt;line-height:115%;font-family:'GFT Corporate SemiBold';color:#5199e2">_</span></p><p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'"><span style="font-size:14.0pt;font-family:'GFT Corporate SemiBold';color:#001326">About the Role</span><span style="font-size:14.0pt;font-family:'GFT Corporate SemiBold';color:#5199e2">_</span></p> <p style="margin:0.0in;text-align:justify;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'"><span style="color:#001326">We are seeking a highly experienced Software Development Engineer to lead and support the migration of ETL jobs and databases from on-premises environments to the AWS Cloud. This position requires a hands-on developer who can build new ETL solutions if necessary, thoroughly understand all existing on-premises ETL jobs, and serve as an expert to guide the team. Key responsibilities include job execution, data validation, ensuring data quality, and adherence to data compliance and business rules. The role also encompasses understanding AWS infrastructure-as-code, developing ETL solutions to replicate on-premises processes in the cloud, orchestrating and validating jobs, and providing comprehensive production support. Candidates must possess technical development expertise and a strong background in data analytics.</span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'"> </p> <p style="margin:0.0in 0.0in 0.0in 14.2pt;text-align:justify;text-indent:-14.2pt;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'"><span style="font-size:14.0pt;font-family:'GFT Corporate SemiBold';color:#001326">A day in this role</span><span style="font-size:14.0pt;font-family:'GFT Corporate SemiBold';color:#5199e2">_</span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in"> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Leverage development experience with DataStage or Informatica, Korn Shell, Python, and Perl scripting on Unix/Linux platforms.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Be able to design, develop, and implement ETL Glue PySpark processes to extract, transform, and load data from various sources into AWS cloud-based data warehouses and data lakes, specifically Redshift and Aurora PostgreSQL.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Be able to develop scalable and efficient full-stack applications, including both front-end and back-end components or APIs, as required.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Conduct business analysis and perform data analysis/ validation to minimize errors and inconsistencies, extract meaningful insights, and support business decision-making throughout the software development lifecycle.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Collaborate closely with data analysts, data architects, and other team members to analyze source data, enhance data accuracy and integrity, implement data reporting, and understand data and application requirements to deliver effective solutions.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Automate and orchestrate ETL processes, applications, and APIs to optimize performance and scalability across both on-premises and cloud environments.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Proactively provide production support, including monitoring, troubleshooting, and resolving issues for ETL processes, configurations, and data integrity.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Develop comprehensive documentation covering overall processes, data mappings, data flows, APIs, application code, and support procedures.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Perform impact analysis and effectively communicate technical processes and concepts to larger audiences.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Ensure data and application security and compliance with all relevant data protection regulations.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Participate in code reviews, adhere to best practices, and provide constructive feedback to peers.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Stay up to date with the latest industry trends and best practices in the areas of ETL development, full-stack development, data analysis, and cloud technologies.</li> </ul> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'"> </p> <p style="margin:0.0in 0.0in 0.0in 14.2pt;text-indent:-14.2pt;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'"><span style="font-size:14.0pt;font-family:'GFT Corporate SemiBold';color:#001326">The expertise requested</span><span style="font-size:14.0pt;font-family:'GFT Corporate SemiBold';color:#5199e2">_</span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in"> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Bachelor’s degree in Computer Science, Information Technology, or a related field.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">More than 8 years of experience in ETL development, data warehousing, AWS cloud services, and API development.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Comprehensive proficiency in all AWS services with a strong understanding of data integration, transformation, and loading processes.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Expertise in scripting languages, including DataStage or Informatica, Shell scripting, Perl, and Python.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Experience with API development and frameworks such as REST and SOAP.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Advanced skills utilizing the AWS cloud platform and services, including AWS Glue, Step Functions, Airflow DAGS, Lambda, S3, EC2, and others.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Proficiency in SQL with both on-premises relational databases (such as DB2 on AIX) and AWS databases (such as Amazon RDS, Amazon Aurora PostgreSQL, and Redshift).</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Experience with version control tools like Git or Bitbucket.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Familiarity with implementing Jenkins pipelines and CI/CD processes.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Demonstrated experience in data analysis/ validation, utilizing tools such as Excel, Python, and Tableau.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">AWS certifications and expertise in AI/ML are advantageous.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Familiarity with automotive industry knowledge, data warehousing concepts, and adherence to developer best practices.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'">Experience working within Agile development methodologies.</li> </ul> <p style="margin:0.0in 0.0in 0.0in 14.2pt;text-indent:-14.2pt;line-height:normal;font-size:12.0pt;font-family:'GFT Corporate Light'"> </p> <p style="text-align:center;margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:'GFT Corporate Light'"><em><span style="color:#001326"> </span></em></p> <p style="text-align:center;margin:0.0in 0.0in 8.0pt;line-height:115%;font-size:12.0pt;font-family:'GFT Corporate Light'"><em><span style="color:#001326">Our Core values are focus to inclusion and diversity, all qualified applicants will be considered for employment and will go thru a fair recruitment process regardless of their race, religion, gender identity, sexual orientation, national origin or disability status.</span></em></p><p style="text-align:center"><span style="font-size:14.0pt;line-height:115%;font-family:'GFT Corporate SemiBold';color:#5199e2">Your journey with us begins here!!</span></p>