Exp: 4 to 9 years
Location: Pune
· Having Good Data Ware House, ETL ( Extract, Transform & Load ) Concepts.
· Experience with Designing a Data Warehouse, Preparing Data Flow Diagram.
· Interpretation of Architecture digram/Data flow diagram and design the ETL solution accordingly.
· Having clear concepts on Slowly Changing Dimension ( SCD Type 1 & Type 2 ), Intermediate table, Truncate/Insert Tables.
· 3. Clear Concepts about various Active & Inactive Transformations.
· Clear Concepts on developing the mapping following coding standards & naming convention. Capable of defining Coding standard for a new development project.
· Clear concepts on Parameterization. Concepts on how to set up the configurations for a new development project.
· Clear concepts on how to troubleshoot an issue in IICS ( Data Preview mode/ setting the Verbose mode in mapping Task ).
· Concepts on various Performance improvement techniques like enabling Cache, Use of Persistent Cache, use of PDO ( Push Down Optimization ) etc.
· Should have experience working with different files ( flat file, JSON/XML, csv, fixed width etc ).
· Should have clear concepts on SQLs - different joins, analytical functions like rank, group by, string manipulation fuction like - substr, instr etc.
· Should have knowledge on usage of basic unix commands - cd, cp, mv, mkdir, chmod, sed, grep, cut, awk etc.
· Should have knowledge on job scheduling, how a third party job scheduler like IBM TWS, HCL DWC or Control M works.
· Should have good stakeholder management skills.
· Should have experience of leading a team.
Advanced/Good to have Skill
· PC to IICS Migration experience.
· Usage of RPA tool.
· Experience of using any Cloud Migration accelerators.
· Any scripting language like shell scripts/Python.
· Experience working in RFP/Estimates."
About Cognizant:
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, bridging the gap between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, drive tangible outcomes and keep global enterprises ahead in a fast-changing world. See how at cognizant.ai or @cognizant.
Additional employment information
Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, state or local laws.










