Opening for SAS Data Analyst

Experience: 6 - 12 Years
Team: Analytics

Job Description

• Interpret data, analyze results using statistical techniques and provide ongoing reports
• Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality
• Acquire data from primary or secondary data sources and maintain databases/data systems
• Identify, analyze, and interpret trends or patterns in complex data sets
• Filter and "clean" data, and review computer reports, printouts, and performance indicators to locate and correct code problems
• Work closely with management to prioritize business and information needs
• Locate and define new process improvement opportunities
• Technical expertise regarding data models, database design development, data mining and segmentation techniques

---

Opening for Data Modeler

Experience: 10 - 15 Years
Team: ETL

Job Description

Responsible for the fundamental organization of a system embodied in its components, their relationships to each other and to the environment, and the principles guiding its design and evolution.

Should be able to:

• Understand and translate business needs into data models supporting long-term solutions.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new/modified environments.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies.
• Validate business data objects for accuracy and completeness.
• Develop data models according to company standards.
• Apply client Standards, checks models in and out of Model Repository, and documents data model translation decisions.
• This position includes use of data profiling tools and techniques, and development of review and QA data requirements.
• 3-5 years prior data analyst experience preferred
• Master (experienced) in using Erwin, IBM Infosphere
• Logical Design Demonstrated experience with large scale, multiple business solutions across divisions or enterprise
• Ability to communicate strategies and processes around data modeling and architecture to cross functional groups and senior levels
• Ability to influence multiple levels on highly technical issues and challenges
• Demonstrated experience to influence and coordinate third parties and suppliers.

---

Opening for ETL Architect

Experience: 10 - 15 Years
Team: ETL

Job Description

• Consulting designing, developing and deploying a business intelligence and data warehousing project.
• Provide consulting to clustering of ETL solution with failover design
• Provide solutions to performance bottlenecks
• Work as a guide and mentor of the development team
• Help manage security of Informatica environments – define guidelines for privileges and roles at ETL level
• Assess nonfunctional requirements and align ETL solution to cater to those
• Provide leadership and direction on ETL portion of project using Informatica PowerCenter, data services - IDQ and MDM.
• Hands-on development using Informatica PowerCenter to create initial ETL load routines and establish standard and templates
• Create design pattern templates for deliverable objects
• Define and implement ETL development standards and procedures
• Define and implement ETL tool configuration
• Ensure effective ETL functional decomposition into deliverable objects
• Ensure ETL quality through reviews
• Strong analysis and design skill
• Strong experience with business intelligence and data warehousing design principles and industry best practices
• Deep understanding of database and data warehouse design concepts and SQL programming
• Understanding of banking domain and CRM would be an added advantage

---

Opening for Informatica MDM-Architect

Experience: 10 - 15 Years
Team: MDM

Job Description

• Should have experience in playing the role of a MDM Architect
• Experience in leading large MDM Implementation.
• Good Knowledge of Hierarchy, GUI/IDD, Match / Merge Process.
• Experience in implementing various models of MDM
• Good Knowledge of at least one Data Quality tool (Quality Stage, Informatica IDQ, Trillium)
• Good Knowledge of at least one ETL Tool (Data Stage, Informatica Power Centre)
• Awareness of MDM trends, MDM Concepts and other tools in the market.
• Should be able to provide guidance and assistance to team members.
• Ability to guide Customers up the MDM value chain.
• Ability to architect, estimate and respond to MDM proposals.
• Knowledge of Data Management Concepts
• Knowledge of basic concepts of Java
• Experience configuring and deploying complex client/server software on Unix and Windows servers
• Strong RDBMS SQL and troubleshooting skills
• Excellent communication skills and capability to engage with customers, stakeholders to drive MDM design-decisions
• Build and standardize best practices, reusable components and accelerators for MDM implementations
• Facilitate setting up a Centre of Excellence for Informatica MDM practice and extend support to Pre-sales and Business consulting teams on MDM solutions

---

Opening for MDM HUB

Experience: 6 - 10 Years
Team: MDM

Job Description

• Should have 5+ years of implementation experience in the Enterprise Data Management space with the Informatica MDM / ETL experience.
• Good experience in using SIF APIs such as Get, SearchQuery, CleansePut, SearchMatch, Merge and Unmerge to develop complex application to communicate with Hub Server and process the data from Base Object.
• Installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter
• Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarch management in MDM Hub implementation.
• Develop the IDD application as per the business needs by creating the subject area and subject area groups.
• Experienced in other Informatica Product suites, mainly Informatica Data Quality (IDQ), Informatica Power center and AddressDoctor.

---

Opening for MDM SIF

Experience: 6 - 10 Years
Team: MDM

Job Description

• Overall experience of more than 2 years implementing Java/J2EE solutions
• At least 4 years of experience implementing MDM solutions using MDM tool
• Experience in mapping development between source data applications and MDM
• Experience in creating detailed design documents for MDM Server
• Experience in designing the MDM process and defining/validating the architecture
• Experience in IDD development, Task assignment process the MDM process
• Should have good Data modeling skills and experience working on Database
• Should have experience working on HM, Match & merge and API's/SIF
• Good understanding of Data Quality concepts including Exact & fuzzy matching techniques.
• Good communication skills and ability to work in multi-vendor environment

---

Opening for MDM Testing

Experience: 6 - 10 Years
Team: MDM

Job Description

• Strong ETL Testing experience with MDM.
• Good knowledge on SQL and database concepts.
• Capable of understanding MDM Designs & architecture.
• Knowledge of full software testing life cycle.
• Working & execution of different MDM services.
• Good experience in QC.
• Test strategy & Test plan preparation.
• Execution of ETL/MDM jobs
• Working with Text & XML files
• Primary level of UNIX scripting

---

Opening for Informatica IDQ

Experience: 6 - 10 Years
Team: MDM / DM

Job Description

• Informatica Data Quality Developer with minimum 2 yrs of experience in IDQ.
• To perform analysis using the IDQ
• Work with the data architects and business partners to build the rules
• Possess strong data analysis experience and ability to interface directly with users, team members and other stakeholders to understand why data is needed, how to process.
• Strong understanding and experience of data governance, data profiling, data cleansing experience using IDQ
• Ability to build new rules and integrate IDQ rules with Database and files
• Capable of creating reports in Informatica.
• Experience in design and build data quality scorecard

Required Skills

• Informatica Data Quality Development
• Data Quality Scorecards
• Strong SQL skills
• Data analysis

Beneficial experience:

• Exposure to CRM systems
• Data warehousing
• Knowledge of Telecom / Financial Services domain.

---

Company Profile

Tech Mahindra represents the connected world, offering innovative and customer-centric information technology services and solutions, enabling Enterprises, Associates and the Society to Rise™. We are a USD 2.7 billion company with 83,000 professionals across 49 countries, helping over 560 global customers including Fortune 500 companies. Our Consulting, Enterprise and Telecom solutions, platforms and reusable assets connect across a number of technologies to derive tangible business value.

We are part of the USD 16.2 billion Mahindra Group that employs more than 155,000 people in over 100 countries. The Group operates in the key industries that drive economic growth, enjoying a leadership position in tractors, utility vehicles, after-market, information technology and vacation ownership.