*Rate:- $50* USG direct client is looking for * Informatica IDQ 9.6.1/Power Center developers *at* NYC, NY*
*Job Description:-* Looking for an experienced Informatica ETL / IDQ Developer to join in our multi-year Master Data Management (MDM) journey. The ETL / IDQ Developer will be to provide full life cycle support for the development and enhancement of the data resources the Enterprise Information team. As an ETL / IDQ Developer, you will be responsible for working closely with application development and business analysis teams to create the logical and physical database designs supporting client and business objectives. The ETL Developer will assist with design and implementation of data warehouses, planning applications and reporting solutions and develop solutions to leverage ETL tools and suggest process improvements. The required skills and experience are: *Extract Transform Load - Informatica Power Center 9.5.1* · Overall 8+ years of experience required · Should have good understanding of all Informatica transformations, source file structures, and debugging jobs. · Design and implementation of complex data integration that are innovative, scalable and high performing within Informatica PowerCenter and PowerExchange. · Perform systems and data analysis to implement Informatica mappings and workflows, shell scripts and stored procedures. · performance tuning of Informatica code and SQL scripts · Should have good understanding of ETL / Informatica Architecture · Develop BMC ctrl-M jobs, SQL scripts for databases - SQL server, Oracle, DB2 · Participate in full life cycle development including requirements gathering, analysis, design, development, testing and documentation. · Perform code reviews and unit testing. · Documentation of design, code and testing. · Communicate with Business Analyst and Data Analyst to understand requirements, socialize ideas among peers, and document work product. · Strong knowledge of SQL and experience on RDBMS like Oracle and MS SQL Server · Communicate with Business Analyst and Data Analyst to understand requirements, socialize ideas among peers, and document work product. · Should be able to articulate and create technical design documents, mapping documents and unit testing documents · Experience writing technical specifications including ETL source to target mapping documents · Effectively code reviews - adheres to quality guidelines & schedules *Data Quality Implementation-Informatica Developer (IDQ) 9.6.1* · Develop/Manage inventory of critical data quality business rule checks. · Applies data analysis, data cleansing, data matching, exception handling, reporting with capabilities of IDQ. · Vet data quality business rules with stakeholders · Implement critical data quality business rules within the toolsets · Develop/implement processes for data quality assessment & remediation · Develop a performance metrics dashboard via Scorecard. · Design and Develop IDQ mapplets and mapping. · Understanding of Address Validation routine via Address Doctor. *Also Desire:* · Informatica Master Data Management knowledge · Excellent analytical and problem solving skills · Excellent communication skills (oral and written) · Strong team player with ability to work in a team and as an individual contributor. · Experience and knowledge in Managed Health Care Service. · Delivery on project goals and development of defect free code. · Cross functional collaboration working with teams to deliver projects on time. *Please share your updated resume at *[email protected]* or feel free to contact me at **614-401-5194* -- You received this message because you are subscribed to the Google Groups "Oracle-HRMS-India" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oracle-hrms-india. For more options, visit https://groups.google.com/d/optout.
