Engineer

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.