Job Title: Senior ETL Engineer
Location: Charlotte, NC (Onsite)
Duration: 12 + months
Employment Type: W2 contract
Job Description We are seeking a highly skilled
Senior ETL Engineer to join our dynamic Data Integration team in Charlotte, NC.
The ideal candidate will have extensive experience in designing, developing, and optimizing ETL (Extract, Transform, Load) processes to support enterprise data warehousing and analytics initiatives.
You will collaborate with cross-functional teams to ensure seamless data integration, improve data quality, and enhance business intelligence capabilities.
Key ResponsibilitiesDesign, develop, and maintain scalable ETL workflows using tools like Informatica PowerCenter, IBM DataStage, or Talend.
Optimize and tune SQL queries, stored procedures, and ETL jobs for performance and efficiency.
Work with large-scale data warehouses (e.g., Snowflake, Teradata, Oracle, SQL Server) and cloud platforms (e.g., AWS, Azure, GCP).
Implement data quality checks, error handling, and logging mechanisms.
Collaborate with data architects, business analysts, and BI teams to understand requirements and deliver solutions.
Automate ETL processes using scripting languages (Python, Shell, PowerShell).
Ensure compliance with data governance, security policies, and regulatory standards.
Mentor junior engineers and provide technical leadership in ETL best practices.
Required Qualifications5+ years of hands-on experience in ETL development and data integration.
Strong expertise in SQL, PL/SQL, or T-SQL with complex query optimization.
Proficiency in ETL tools (Informatica, DataStage, SSIS, Talend) and scheduling tools (Autosys, Control-M).
Experience with big data technologies (Hadoop, Spark, Kafka) is a plus.
Knowledge of cloud-based data solutions (AWS Glue, Azure Data Factory, Snowflake).
Familiarity with Agile/Scrum methodologies and CI/CD pipelines.
Strong problem-solving skills and ability to troubleshoot data pipeline issues.
Bachelor’s or Master’s degree in Computer Science, Engineering, or related field.
QualificationsExperience in financial services or banking domains.
Certifications in ETL tools, cloud platforms, or data engineering.
Knowledge of real-time data processing and streaming ETL.