Job Title: Lead SQL Developer
Location: Charlotte, NC
Travel/Relocation/Remote: Remote till covid stabilizes
SQL Developer Responsibilites Ability to dodevelopment of data services and integrations with On Prem and Cloud native stack Collaborate with architects analysts modelers and domain SMEs Responsible for working within a team to deliver data integrationand engineeringprojects across a wide variety of systems in support of business functions and processes to improve end user experience What does your success look like in thefirst 90 days In the first 90 days What are we looking for We want strong collaborators who can deliver a world class client experience We are looking for peoplewho thrive in a fast paced environment are client focused team oriented and are able to execute in a way that encourages creativityand continuous improvement Requirements 7 Years of experience inMS SQL Server Good hands on experiencewithANSI SQL T SQL programming Proficientin creating Stored Procedures Functions Triggers Tables and Views Proficient in writing complex queriesusing joins Experience in analyzing existing SQL queries for performance improvements Experience in troubleshooting optimization and performance tuning using SQL Profiler Performance Monitor and Execution Plan Working knowledge of NoSQL Ability to dodevelopment of data services and integrations on cloud native stack and on prem stack Collaborate with architects analysts modelers and subject matter experts in domain and data modeling Responsible for working within a team to deliver data integration projects across a wide variety of systems in support of business functions and processes to improve end user experience Design develop document and test data engineeringsolutions using industry standard tools Understand and support metadata management and information practices that improves its usability through its lifecycle Present designs to team members and convey complex information in a clear and concise manner Maintain technical documentation that facilitate understanding maintaining reusing and code refactoring Experience using one or more ETL tools to orchestrate and ingest data Experience with DevOps toolchain that enables CI CD pipeline e g GitHub TFS Jenkins TeamCity Octopus Puppet Experience with Agile development processPreferences Experience in PySpark Experience working on Lambda with AWS Experience in AWS Redshift Experience in development on cloud based ETL tools like Talend AWS Glue is an added advantage
• Batcheler’s degree
• 9+Years of experience
Capgemini 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.
This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Click the following link for more information on your rights as an Applicant – http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law
Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by Capgemini.