Posted in Information Technology 30+ days ago.
Type: Full-Time
Location: Oakland, California
Cognizant will not sponsor H-1B or other U.S. work authorization for this role.
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
· 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.
· 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 Ab-Initio GDE.
· 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 |
* 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. |
Foods Co.
|
Foods Co.
|
Foods Co.
|
Best Buy
|
SUMITOMO RUBBER NORTH AMERICA INC
|
COLSON GROUP HOLDINGS, LLC
|