design and implement industry best ETL technologies to satisfy client requirements
design and develop optimal code to maintain exceptional performance in processing large volumes of data
translate business requirements into technical specifications
design, develop, and test ETL solutions and automating data loading processes
establish ETL environments according to project requirements
develop and implement an efficient migration process to move ETL objects from development to test and production environments
support the project team throughout the design, development and testing process
participate in all design reviews and requirement sessions, as required
support project documentation, as required
understand database design, programming concepts, data modeling, and framework management
communicate ideas to both technical and non-technical people at all levels of the organization
work with Business Analysts, Data Architects, Enterprise Architects, and ETL Architects to ensure business requirements are being met with the solution being developed
identify and reuse of ETL components and services to avoid duplicative implementations
mentor other team members in developing, documenting and modifying ETL components
develop advanced and complex ETL processes in the AWS GovCloud using the tools such as AWS Glue, S3, Python, Spark, SQL, Athena
support and administer the MySql database in the migration environment on the cloud
Requirements
6 + years of related experience
US Citizenship Required
Excellent written and oral communication skills
5+ years of working experience working with some industry leading ETL tools such as Informatica, ODI
1 year of working knowledge Langchain, CrewAi , Llama or other LLM services
2 years of working knowledge of the AWS data services – S3, Glue, Lambda, Sagemaker AI, EMR, RDS(relational data service) and other AWS services
4+ Years of working experience on the MySql, Oracle or any other RDBMS database
demonstrated history of working in large enterprise level applications
experience in working with database applications and SQL
full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized, database optimization techniques and other such data architecture best practices
ability to work with various stakeholders with different technical abilities to gather data requirements
experience working in cloud environments
experience working in Agile development environments
track record of the delivery in challenging, face-paced environments
BS or equivalent +6 yrs related experience, or MS + 3 yrs related experience
Tech Stack
AWS
Cloud
ETL
Informatica
MySQL
Oracle
Python
RDBMS
Spark
SQL
Benefits
variety of medical plan options, some with Health Savings Accounts
dental plan options
vision plan
401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match
full flex work weeks where possible
variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave
15 days of paid leave per calendar year
additional 10 paid holidays per year
GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees
short and long-term disability benefits
life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance