Senior ETL Developer - testing - mounika
PMCS Services, Inc.
Austin, TX
Close: $10 - $10 HOUR
ETL Developer
Position Overview: Responsible for designing, developing, and maintaining Extract, Transform, Load (ETL) processes to move and integrate data between various systems and databases.
Key Responsibilities:
- Design and develop ETL workflows to extract data from multiple source systems
- Transform raw data according to business rules and requirements
- Load processed data into target databases, data warehouses, or data lakes
- Monitor and troubleshoot ETL processes to ensure data accuracy and reliability
- Optimize ETL performance and resolve data quality issues
- Collaborate with data analysts, database administrators, and business stakeholders
- Document ETL processes and maintain technical specifications
- Perform data validation and testing to ensure data integrity
Required Skills:
- Proficiency in ETL tools (e.g., Informatica, Talend, SSIS, DataStage)
- Strong SQL skills and database knowledge
- Experience with scripting languages (Python, Shell, PowerShell)
- Understanding of data warehousing concepts and methodologies
- Knowledge of data modeling and database design
- Familiarity with scheduling tools and job automation
- Problem-solving and analytical thinking abilities
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or related field
- 2-4 years of experience in data integration or ETL development
- Experience with relational databases (SQL Server, Oracle, MySQL, PostgreSQL)
- Knowledge of cloud platforms (AWS, Azure, GCP) preferred
