This job listing has expired and the position may no longer be open for hire.

Informatica Senior Developer at Cognizant

Posted in Information Technology 30+ days ago.

Type: Full-Time
Location: WOODLAND HILLS, California





Job Description:

About AI & Analytics: Artificial intelligence (AI) and the data it collects and analyzes will soon sit at the core of all intelligent, human-centric businesses. By decoding customer needs, preferences, and behaviors, our clients can understand exactly what services, products, and experiences their consumers need. Within AI & Analytics, we work to design the future—a future in which trial-and-error business decisions have been replaced by informed choices and data-supported strategies.

By applying AI and data science, we help leading companies to prototype, refine, validate, and scale their AI and analytics products and delivery models. Cognizant’s AIA practice takes insights that are buried in data, and provides businesses a clear way to transform how they source, interpret and consume their information. Our clients need flexible data structures and a streamlined data architecture that quickly turns data resources into informative, meaningful intelligence.

*Please note, this role is not able to offer visa transfer or sponsorship now or in the future*









·         Perform detail design, development, documentation, debugging and implementation of solutions for Informatica ETL requirements. 

·         Should have strong skills on ETL design patterns and data architecture, UNIX and Oracle, DB2, Teradata, Netezza, SQL Server 

·         Should possess strong Teradata ETL design and implementation skills and strong in writing Advanced SQLs to perform the desired activities  

·         To provide end to end ETL Design solutions and support Architecture in defining strategies. Leading team of designers and developers 

·         To understand the overall purpose of the projects and contribute to requirements & data analysis, and provide solutions from an ETL perspective 

·         Delivery of low level design documents with ETL & DWH strategy, standards and adhering to ETL & BIW principles & policies. 

·         Strong understanding of ETL, Application Data Integration, DWH and Report designs with functional and non-functional assessment for global implementations. 

·         Identify data source for different type of Customer data and analyze applications / system data 

·         Accountable for project related queries/issues. 

·         Should be well versed with following Informatica PowerCenter Client’s tool set – 

o    Informatica PowerCenter Designer - Mapping Development 

o    Informatica PowerCenter Workflow Manager – Workflow Development 

o    Informatica PowerCenter Workflow Monitor – Job Monitoring 

o    Informatica PowerCenter Repository Manager – Building Code Deployment Queries  

o    Good exposure of Informatica Command line utilities such as pmcmd, pmrep, etc. 

o    Able to design end to end ETL solution for complex case studies. 

·         Working knowledge of at least one Job scheduler tool. 

·         Identify data source for different type of Customer data and analyze applications / system data 

·         Using all of the above components to create and maintain an enterprise data solution and rules execution. 

·         Must have hands-on experience with SQL, Shell Scripting, bash, Korn shell scripting, SQL performance tuning, relational model analysis and data migration. 

·         Strong in Teradata Stored Procedures, BTEQ, Utilities

·         Should have good communication skills and client handling skills. 

·         Strong knowledge in BI and Data Warehousing. 

 



Position Qualifications: 

·         Bachelor’s Degree in Engineering or relevant field. 

·         7+ years of success in consultative/complex deployment project, architecture, design, implementation and/or support of data and analytics solutions. 

·         Hands on development Design and Develop applications using Informatica. 

·         Experience in data warehousing projects implementing data models using Teradata database 

·         Excellent skill in Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor, Repository Manager, Command line utilities such as pmcmd, pmrep, etc. 


 #LI-MS3

#CB

IND123

Technical Skills






































SNo Primary Skill Proficiency Level * Rqrd./Dsrd.
1 Informatica PowerCenter PL3 Required
2 SQL Scripting PL3 Required
3 Oracle PL2 Required
4 Unix Shell Scripting PL1 Required
5 Teradata PL1 Required

 

* Proficiency Legends






















Proficiency Level Generic Reference
PL1 The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels.
PL2 The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects.
PL3 The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects.
PL4 The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.





More jobs in WOODLAND HILLS, California


Cushman & Wakefield

Cushman & Wakefield

Cushman & Wakefield
More jobs in Information Technology


Pike Electric, Inc.

Pike Electric, Inc.

Vistra Corporate Services Company