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.
Language requirements vary depending on roles, but we ask that all candidates have basic English proficiency for company-wide communications purposes. For roles based in Quebec, professional English proficiency is required, as you’ll deliver services to and collaborate with stakeholders outside the province who may not speak French.
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, provincial or local laws.
If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.
