Senior ETL Developer

Raas Infotek LLC

Texas City, TX, United States

6 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Amazon Web Services Microsoft Azure Code Review Continuous Integration Data Validation Data Integration Extract Transform Load (ETL) Data Migration Data Mining Data Warehousing Database Development Database Schema

+25 more

Dimensional Modeling Python (Programming Language) PostgreSQL Microsoft SQL Server Operational Databases Oracle (Applications) Cloud Services Shell Script SQL Stored Procedures PL-SQL SQL Databases Freeform SQL Google Cloud Azure Data Factory Informatica Powercenter Snowflake Git Pyspark Information Technology AWS Glue Star Schema Real Time Data Apache Kafka Data Pipelines Databricks

Job description

We are seeking an experienced Senior ETL Developer with 10+ years of experience in designing, developing, and maintaining enterprise data integration and ETL solutions. The ideal candidate should have strong expertise in ETL development, SQL, data warehousing, Informatica, and cloud data platforms., * Design, develop, and maintain scalable ETL/ELT pipelines.

Develop complex ETL workflows for data extraction, transformation, and loading.
Analyze business requirements and translate them into technical ETL solutions.
Develop and optimize complex SQL queries, stored procedures, and database objects.
Perform data validation, reconciliation, cleansing, and quality checks.
Troubleshoot ETL jobs and resolve production data issues.
Work with data architects, business analysts, developers, and QA teams.
Optimize ETL processes for performance and scalability.
Support data migration and integration projects.
Create technical documentation and participate in code reviews.
Support deployment and production activities through CI/CD processes.

Requirements

10+ years of experience in ETL/Data Integration Development.
Strong hands-on experience with Informatica PowerCenter / Informatica IICS.
Strong expertise in SQL, PL/SQL, and database development.
Experience with Oracle, SQL Server, or PostgreSQL.
Strong understanding of Data Warehousing, Dimensional Modeling, Star and Snowflake Schemas.
Experience with ETL performance tuning and optimization.
Experience with Data Quality, Data Validation, and Data Migration.
Knowledge of Unix/Linux shell scripting.
Experience with Git and CI/CD tools.
Strong analytical, troubleshooting, and communication skills.

Preferred Skills

Experience with cloud data platforms such as AWS, Azure, or Google Cloud Platform.
Knowledge of Azure Data Factory, AWS Glue, Databricks, or Snowflake.
Experience with Python/PySpark.
Knowledge of Kafka or other real-time data integration technologies.
Experience with Banking, Healthcare, Insurance, Retail, or Financial Services domains.

Education

Bachelor’’s or Master’’s degree in Computer Science, Information Technology, Engineering, or a related field.

Nice to Have Certifications