Senior ETL Developer - testing - mounika

PMCS Services, Inc. · Austin,Close:
$1 - $1 YEAR
Term:Full timeWork:Onsite
Type:EmployeeContract

About the Role
We are seeking a highly skilled Senior ETL Developer to join our dynamic data engineering team. This role offers an exciting opportunity to lead complex data integration projects, architect scalable ETL solutions, and drive data-driven decision making across our organization. The ideal candidate will have extensive experience in designing, developing, and optimizing ETL processes while ensuring data quality and integrity at enterprise scale.

Key Responsibilities


ETL Development & Architecture

  • Design, develop, and maintain complex ETL workflows using industry-standard tools (Informatica PowerCenter/Cloud, SSIS, or similar)
  • Build robust data pipelines capable of processing large volumes of data (millions of records daily)
  • Create and optimize data transformation logic for multiple source systems
  • Implement data quality frameworks and validation procedures
  • Develop real-time and batch data integration solutions

Data Management & Quality

  • Perform comprehensive data profiling and analysis to understand source system characteristics
  • Design and implement data quality checks, cleansing procedures, and error handling mechanisms
  • Establish data governance standards and ensure compliance with data policies
  • Create and maintain data lineage documentation and impact analysis
  • Monitor ETL job performance and implement optimization strategies

Technical Leadership

  • Lead technical discussions and provide expertise in ETL best practices
  • Mentor junior developers and conduct code reviews
  • Collaborate with data architects to design scalable data warehouse solutions
  • Work closely with business stakeholders to translate requirements into technical specifications
  • Participate in technical architecture decisions and solution design

System Integration & Support

  • Integrate data from diverse sources including databases, APIs, flat files, and cloud platforms
  • Troubleshoot and resolve complex data integration issues
  • Provide production support and maintain SLA compliance
  • Implement monitoring and alerting solutions for ETL processes
  • Participate in deployment activities and change management processes

Required Qualifications


Technical Skills

  • 5+ years of hands-on experience in ETL development and data integration
  • Informatica PowerCenter/Cloud or equivalent ETL tools (SSIS, Talend, DataStage)
  • Advanced SQL skills with experience in query optimization and performance tuning
  • Database expertise in Oracle, SQL Server, MySQL, or PostgreSQL
  • Data modeling experience with dimensional modeling and star schema design
  • Scripting languages such as Python, Shell, or PowerShell
  • Version control systems (Git, SVN) and deployment automation

Experience Requirements

  • Proven track record of delivering large-scale data integration projects
  • Experience with data warehousing concepts and methodologies
  • Knowledge of data quality tools and frameworks
  • Experience in performance tuning of ETL processes and databases
  • Familiarity with Agile/Scrum development methodologies

Preferred Qualifications

  • Cloud platforms experience (AWS, Azure, GCP) with services like Redshift, S3, Glue
  • Big Data technologies (Hadoop, Spark, Kafka) knowledge
  • Data science integration experience with Python libraries (pandas, NumPy)
  • Business Intelligence tools (Tableau, Power BI, QlikView)
  • Experience with real-time data processing and streaming technologies
  • Knowledge of DevOps practices and CI/CD pipelines for data projects

Industry Experience (Preferred)

  • Healthcare: HIPAA compliance, patient data management, case management systems
  • Financial Services: Regulatory reporting, risk management data, compliance frameworks
  • Government/Public Sector: Case management, inter-agency data sharing, compliance requirements
  • Retail/E-commerce: Customer data integration, inventory management, analytics

Education & Certifications
Education
  • Bachelor's degree in Computer Science, Information Technology, Engineering, or related field
  • Master's degree in Data Science, Analytics, or related field (preferred)

Certifications (Preferred)
  • Informatica PowerCenter/Cloud Developer Certification
  • Oracle/SQL Server Database Administrator Certification
  • AWS/Azure Data Engineering Certifications
  • Microsoft Certified: Azure Data Engineer Associate
  • Google Cloud Professional Data Engineer

Must-Have Skills

  • ETL Development (5+ years)
  • Informatica PowerCenter/Cloud
  • Advanced SQL & Database Management
  • Data Quality & Validation
  • Data Warehouse Concepts
  • Python/Scripting Languages

Nice-to-Have Skills

  • Cloud Platforms (AWS/Azure/GCP)
  • Big Data Technologies
  • Real-time Data Processing
  • Machine Learning Integration
  • DevOps/CI-CD for Data
  • Business Intelligence Tools
Updated on