Previous Job
Previous
Senior Informatica ETL Developer-New York, NY
Ref No.: 18-04048
Location: New York, New York

Senior Informatica ETL Developer
Location: New York, NY
Duration: Contract
Rate: DOE

US citizen, Green Card and EAD preferred.

Required Skills:
· ETL, Informatica, Oracle, SQL Queries, Stored procedures, Teradata

Qualifications:
· Bachelor's degree or equivalent, relevant experience.
· 10+ years of experience in ETL/ELT development in business intelligence/data integration projects.
· 10+ years of data analysis and data quality.
· 10+ years of experience working with ETL tools like Informatica, Golden Gate, etc.
· 10+ years of experience working with Relational Databases such as Teradata, Vertica, Oracle, SQL Server, etc.
· 5+ years of experience working with Unix Shell Scripts.
· Experience with data analysis, data architecture, and data cleansing and data quality.
· Experience with data integration tools like Informatica, Data Stage.
· Experience with databases technologies like Oracle, Teradata and Vertica.
· Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data.
· Experience in writing complex SQLs to analyze and troubleshoot the issues/problems.
· Thorough knowledge of MS-Office Suite (Word, Excel, PowerPoint, Access).

Duties and Responsibilities:
· Work with various business stakeholders to identify their information needs.
· Work with data architecture team to understand the source and target data models.
· Work closely with cross-functional business and business intelligence teams to document ETL requirements and turn them into ETL jobs.
· Develop, adhere to, and be a proponent for data warehouse development standards, including ETL standards and best practices.
· Provide documentation for all developed ETL processes, including process flow and source and target mapping.
· Conduct ETL performance tuning and troubleshooting.
· Work with business intelligence operations team to ensure control objectives are implemented for all data movement processes, implement change control for production data, establish and follow proper incident management procedures.