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.