Senior Informatica ETL Developer-New York, NY - Georgia IT Inc.
New York, NY
About the Job
Job Title: Senior Informatica ETL Developer
Location: New York, NY
Rate: DOE $/hr. on w2 only
Position Type: contract
Interview Process: Phone Followed by F2F
US Citizen, Green Card and GC EAD,TN
Job Description:
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.
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, 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
Location: New York, NY
Rate: DOE $/hr. on w2 only
Position Type: contract
Interview Process: Phone Followed by F2F
US Citizen, Green Card and GC EAD,TN
Job Description:
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.
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, 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
Source : Georgia IT Inc.