Must Have Technical/Functional Skills
Primary Skill: Informatica IDMC Developer
Secondary: Oracle, Hadoop
Experience: Minimum 8 years
Roles & Responsibilities
· Bachelor’s or master’s degree in computer science or related field.
· Minimum 2 years experience in IDMC migration projects.
· ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
· Experience in Agile Methodology
· Experience with code versioning tools like Bit-Bucket
· SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data.
· Exposure to advanced transformations like data transformations, Parsing JSON/XML messages
· Experience in Job scheduling tools Like Autosys
· Experience with HDFS, MapReduce, and Hadoop ecosystems.
· Understanding data storage and data processing techniques in Hadoop
· Data Integration: Integrate data from various sources, ensuring data consistency and quality.
· Data Warehouse Design: Design and maintain data warehouses to support business intelligence activities.
· Performance Optimization: Optimize SQL script/queries for speed and efficiency.
· Troubleshooting: Identify and resolve issues in ETL processes.
· Documentation: Create and maintain technical documentation for ETL processes.
· Testing: Perform unit, integration, and system testing on ETL processes.
· Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes.
· Data Quality: Ensure data quality by implementing data cleansing and transformation processes.
· Data Modeling: Develop and maintain relational and dimensional data models.
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range: $100,000 - $130,000 a year
More Information
Application Details
- Organization DetailsTCS / Tata Consultancy Services


Recommended Comments
There are no comments to display.
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.