Informatica Tech Lead

Location: Worcester, MA, United States
Date Posted: 11-21-2018
Job Title : Informatica Tech Lead
Location  : Worcester, MA​.

Job Duties :
Provide ETL Development expertise in relational database management concepts and data warehousing best practices and tools using Informatica Version 9.5x and above.
Job includes adhering to ETL design standards, procedures and best practices in Informatica; transformations, mappings, sessions, workflows, implementing business rule as per requirement, building RTM, data model documentation and data integration strategy. Development of Source-to-Target mapping design specifications, data dictionaries, review database schemas Develop and test Extract, Transformation, and Loading (ETL) modules based on design specifications using Informatica Version 9.5x and above. Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed. This could be automated using mappings to parse code and report on exceptions.
Performance tuning of Informatica mappings.
Support development teams with troubleshooting issues.
On Call Support as required during the week ends and off hours. Scheduling jobs through scheduling tool (i.e. IBM Maestro, Tivoli or Autosys or similar tools) for monthly and daily job cycles.
Root Cause analysis for ETL job failures/Data issues raised by business.
End of Life system verification and upgrades. Perform regression testing and approve the overall upgrade or setup.
Mentor and monitored offshore and onsite development teams with regular calls on the commonly raised issues and propose permanent fixes. Service Now (or similar tools like JIRA, Remedy) ticket handling and problem ticket analysis. Required Skills 5+ years of experience with the following:- Strong experience in Informatica and ETL Strong database analysis skill using SQL / PLSQL / Stored Procedures / Views / Materialized Views.
Oracle and SQL database hands-on experience. Should be proficient in writing stored procedures, good SQL Queries using Oracle. Proficient in building staging environments, Operational Data Stores (ODS) and Data Marts.
Strong Unix shell scripting. Demonstrated skill and ability in the development of data warehouse projects/applications (Oracle & SQL Server) Strong analytical skills and eagerness to learn domain and functional aspects Excellent communication skills, both verbal and written Education and Certifications Bachelor’s degree in Technology or Engineering or equivalent combination of education and work experience.

Central Business Solutions, Inc,
37600 Central Ct.
Suite #214
Newark, CA 94560.
Central Business Solutions, Inc(A Certified Minority Owned Organization)
Checkout our excellent assessment tool:
Checkout our job board :
Central Business Solutions, Inc
37600 Central Court Suite 214 Newark CA, 94560
Phone: (510)-713-9900, 510-573-5500 Fax: (510)-740-3677
this job portal is powered by CATS