What are the responsibilities and job description for the ETL Developer position at Capgemini?
Sogeti is a leading provider of professional technology services, specializing in Application Management, Infrastructure Management and High-Tech Engineering. Sogeti offers cutting-edge solutions around Testing, Business Intelligence, Mobility, Cloud and Security, combining world class methodologies and the global delivery model, Rightshore®. Sogeti brings together more than 20,000 professionals in 15 countries and is present in over 100 locations in Europe, the US and India. Sogeti is a wholly-owned subsidiary of Cap Gemini S.A., listed on the Paris Stock Exchange.At Sogeti USA, we are committed to building a long and enduring relationship with our employees and to creating an environment that rewards and empowers. Our mission is to constantly exceed our employees' expectations in the same way that we strive to exceed our clients' expectations. We offer an environment that celebrates innovation and helps you to achieve a good balance between your professional and personal life. We strive to be an employer of choice!What You-ll DoWe are seeking AWS Glue ETL developer lead with expertise in AWS Glue Cloud Service. Reading source data systems and use AWS Glue for ingestion and transformation of the data in S3 buckets or target databases in AWS. Individual must have keen analytical skills. Looking for a developer with strong experience in ETL, AWS Glue.EDUCATION REQUIREMENTBachelor degree in Computer Science, Information Systems or related fieldYour future duties and responsibilities : Strong hands-on experience in native AWS Glue ETL engineering, operationalization, automation build-out, integration with other native AWS services like S3, RDS, RedShift & Lambda.Design, build and launch new data extraction, transformation and loading processes.Strong knowledge of data structures and algorithms.Experienced writing multi-threaded programs requiring concurrency and synchronization primitives.Ability to drive tasks to completion and take ownership of projects by working in a fast paced agile development environment.Mentor other engineers, defining our challenging technical culture with sharp analytical abilities, and proven design skills.Strong written and oral communication skills; Ability to communicate effectively with technical and non-technical staff.Required qualifications to be successful in this role : Deep technical skills in AWS Glue (Crawler, Data Catalog, DataBrew) : 3 years (Must)ETL & data process automation : 2 years (Must)Oracle & Netezza SQL, PL / SQL experience : 2 years (Must)Step Functions, Lambda, CloudFormation : 3 years (Preferred)Experience with source code control systems and concurrent development workflows : 2 years (Preferred)ETL : 8 years (Preferred)Amazon EMR : 3 years (Optional)Additionally, familiarity with any of the following highly desirable : Jira, Confluence, Bitbucket, Urban Code, GitLab, Jenkins, PythonDesired qualificationsAWS solutions architect and / or AWS developer certification is preferredMinimum education qualificationBachelor's Degree in Computer Science, Computer Engineering, MIS or related field.The benefits our employees enjoy : 401(k) Savings Plan- Matched 150% up to 6%. (Our 401k is in the top 1% of 401(k) plans offered in the US!)Medical / Prescription / Dental / Vision Coverage!Low-premium and deductible. Plan with free preventive care.$12,000 in Tuition Reimbursement100% Company-paid mobile phone planPersonal Time Off (PTO)- Ensuring a balance of work and home lifeSogeti is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity / expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.
