Job Opportunity: Data Engineer - Washington, DC, Reston, VA, Mc Lean, VA - 12 months + (Potential for Extension)

[Venu Goud]

Job Opportunity: Data Engineer

Location: Washington, DC, Reston, VA, Mc Lean, VA

Duration: 12 months + (Potential for Extension)

Send me the resumes to Ve...@techrakers.com

Only H1B's or OPT's. Only 6 years of experience.

                                                                                                                                                                                                                                           

Job Description:

•              Design, develop, and maintain data pipelines and ETL/ELT processes using Python and SQL.

•              Develop and optimize complex SQL queries, stored procedures, and database objects for reporting and analytics.

•              Perform source-to-target data mapping and execute comprehensive data quality validation to ensure data integrity and consistency.

•              Work with AWS data services, including AWS Lambda, Amazon Redshift, Apache Iceberg, and Amazon Glacier, to build and support scalable data solutions.

•              Collaborate with business stakeholders, data analysts, and developers to understand business requirements and translate them into technical solutions.

•              Develop, execute, and maintain test cases for data validation, ETL processes, and reporting solutions.

•              Create and maintain technical documentation, including design documents, mapping documents, data dictionaries, and operational procedures.

•              Participate in Agile ceremonies, including sprint planning, daily stand-ups, backlog grooming, and retrospectives.

•              Track work items, defects, and enhancements using JIRA and contribute to continuous process improvements.

•              Troubleshoot production issues, perform root cause analysis, and implement corrective actions.

 

Required Qualifications

•              Strong programming experience in Python.

•              Advanced proficiency in SQL, including complex query development and performance optimization.

•              Solid understanding of Business Intelligence (BI) concepts, reporting, and analytics.

•              Strong knowledge of relational databases and database design principles.

•              Hands-on experience with AWS services

•              Strong documentation and technical writing skills.

•              Ability to work collaboratively in a fast-paced team environment.