Etl Technical Lead- On Site

Description
This in-person position isopen to any qualified applicant in the United States and Canada
Location: Woodland Hills, CA
*Please note, this role is not able to offer visa transfer or sponsorship now or in the future*
Practice - AIA - Artificial Intelligence and Analytics
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 provide businesses with 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.
Job Duties and Responsibilities:

• Work with the client on the overall deliverables plan
• Co-ordinate with the offshore team and other vendors as required to provide necessary inputs, clarifications to enable quality delivery
• Perform design, development, documentation, debugging and implementation of solutions for Informatica ETL requirements.
• Deliver low-level design documents with ETL & DWH strategy, standards and adhering to ETL & DW principles & policies.
• Accountable for any development and build related queries/issues.
• SQL performance tuning, relational model analysis and data migration.
• Design end-to-end ETL solution for complex case studies.

Position Qualifications:

• Experienced ETL Technical lead with 10-12 years of experience.
• Excellent skill in Informatica PowerCenter Client Tools. Should be well versed with following Informatica PowerCenter Client's tool set - Informatica PowerCenter Designer, Informatica PowerCenter Workflow Manager, Informatica PowerCenter Workflow Monitor, Informatica PowerCenter Repository Manager
• Good exposure of Informatica Command line utilities such as pmcmd, pmrep, etc.
• Working knowledge of at least one Job scheduler tool
• 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
• Strong analytical skills (able to read/write complex SQL queries to analyze data, investigate defects, validate data quality, etc.).
• Solid experience in any one of the relational database
• Experience in working with XML and JSON
• Strong documentation skills (scope, requirements, high-level design)
• Exposure to Informatica Cloud
• Exposure to Data modeling - dimensional and relational modeling

Salary and Other Compensation:
The annual salary for this position is between $160,000- $170,000 USD depending on experience and other qualifications of the successful candidate.
This position is also eligible for Cognizant's discretionary annual incentive program and stock awards, based on performance and is subject to the terms of Cognizant's applicable plans.
Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits 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.
Cognizant is an Equal Opportunity Employer M/F/D/V. Cognizant is committed to ensuring that all current and prospective associates are afforded equal opportunities and treatment and a work environment free of harassment.
Cognizant is recognized as a Military Friendly Employer and is a coalition member of the Veteran Jobs Mission. Our Cognizant Veterans Network assists Veterans in building and growing a career at Cognizant that allows them to demonstrate the leadership, loyalty, integrity, and commitment to excellence instilled in them through participation in military service.
#Ind123