Previous Job
Senior Informatica ETL Developer-New York, NY
Ref No.: 18-02035
Location: New York, NY, New York
Senior Informatica ETL Developer
Location: New York, NY
Position: Contract
Rate      : DOE
US Citizen, Green Card, TN, GC EAD and H4 EAD only No Third-party agencies corp to corp.
  • 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, GoldenGate, 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, 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).
Required Skills:                
  • ETL, Informatica, Oracle, SQL Queries, Stored procedures, Teradata
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.