ETL Developer
New York, New York, United States of America
Contract
2 weeks ago
$60 - $70 USD
Key skills
PythonSQLShellETLData EngineeringData WarehousingAnalyticsBIBusiness IntelligenceTableauPower BISnowflakeSparkApache SparkHadoopAWSAmazon Web ServicesAzureGoogle CloudPostgreSQLMySQLOracleSQL ServerGitVersion ControlCI/CDCommunication
About this role
ETL Developer
Location: NYC, Midtown Manhattan (5 days onsite).
An ETL (Extract, Transform, Load) Developer is responsible for designing, developing, and maintaining data pipelines that extract data from multiple sources, transform it into usable formats, and load it into data warehouses or data lakes for reporting and analytics.
Key Responsibilities
- Design, develop, and maintain ETL workflows and data pipelines
- Extract data from various sources:
- Databases (Oracle, SQL Server, MySQL)
- APIs, flat files, cloud sources
- Transform data by:
- Cleaning, validating, and standardizing datasets
- Applying business rules and transformations
- Load data into:
- Data warehouses, marts, or data lakes
- Develop and optimize:
- Complex SQL queries and stored procedures
- Data integration processes for performance and scalability
- Perform:
- Data validation, reconciliation, and quality checks
- Troubleshoot:
- ETL job failures and data inconsistencies
- Collaborate with:
- Data analysts, data engineers, and business stakeholders
- Support:
- Reporting tools and BI platforms
Required Skills & Qualifications
Technical Skills
- Strong proficiency in:
- SQL / PL-SQL
- Data warehousing concepts
- Hands-on experience with ETL tools such as:
- Informatica PowerCenter
- Talend
- Microsoft SQL Server Integration Services (SSIS)
- Experience working with:
- Relational databases (Oracle, SQL Server, PostgreSQL)
- Knowledge of:
- Data modeling (Star schema, Snowflake schema)
- Data integration and transformation techniques
Preferred / Additional Skills
- Experience with:
- Big data tools (Apache Spark, Hadoop)
- Cloud platforms (Amazon Web Services, Microsoft Azure, Google Cloud Platform)
- Familiarity with:
- Python or shell scripting
- CI/CD pipelines for data engineering
Domain Knowledge (Nice to Have)
- Understanding of:
- Business intelligence and reporting
- Financial, healthcare, or retail data domains
Soft Skills
- Strong analytical and problem-solving abilities
- Attention to detail and data accuracy
- Good communication and teamwork skills
- Ability to manage multiple tasks and deadlines
Typical Tools & Technologies
- ETL Tools: Informatica, Talend, SSIS
- Databases: Oracle, SQL Server, PostgreSQL
- Scripting: Python, Shell
- BI Tools: Power BI, Tableau
- Version Control: Git
Certifications (Optional)
- Informatica Certification
- Microsoft Certified: Data Engineer Associate
- Cloud certifications (AWS, Azure, Google Cloud Platform)