Engineer
Tata Consultancy Service Limited
Job Description
Skill: Informatica IDMC Developer Must Have Technical/Functional Skills: Primary Skill: Informatica IDMC Developer Secondary: Oracle, SQL Experience: Minimum 2 years Roles & Responsibilities 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. 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. Salary Range - $100,000-$130,000 a year 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.