Position: AWS Python Developer
Location: Dallas, TX
Duration: 6+ Months
Experience: 10+
Detailed Job Description:
- 1+ year of experience as a Data Engineer building and maintaining data pipelines and supporting BI initiatives,
- 9 yrs experience in Data Reconciliation, ETL Testing, BI Report Testing, and Manual Testing in the Digital Media, Financial, and Banking domains.
- Skilled in SQL, Python, and data modeling with a strong foundation in traditional ETL workflows.
- Strong working knowledge of Python libraries NumPy, Pandas, and Matplotlib.
- Experienced in writing complex SQL queries for data retrieval, manipulation, and analysis using Snowflake, SQL Server, and AWS Athena.
- Expertise in validating Extract, Transform, Load (ETL) processes to maintain data quality and consistency.
- Ability to detect and resolve data discrepancies efficiently Expertise in analyzing data flow between the source, target system, and BI reports.
- Performed data reconciliation, source-to-target mapping, and transformation validation
- Experience writing test scripts using SQL and Python (Pandas) for data validation testing.
- Good understanding of Data Warehouse concepts, Star Schema, Snowflake, FACT, and Dimension tables.
- Experience in BI report testing (Sigma Computing).
- Experience in API testing using Postman and Swagger.
- Experienced in methodologies like Agile and waterfall.
- Experienced in agile project management with Jira for tracking issues and managing development tasks.
- Implemented CI/CD pipelines using Jenkins for efficient deployment and automation.