Informatica Etl Developer (Remote)

Mars Data Hiring for Informatica ETL Developer positions in Remote locations.

Skills: ETL on Informatica Power Centre, Informatica Data Quality tools, SQL, Oracle, SQL Server, Hadoop, Spark, Cloudera.

Job Title: Informatica ETL Developer

Location: Remote / WFH

Job Type: Fulltime

Relevant IT Exp: 8+ years

Notice Period: Immediate to 30 days

Key Responsibilities

·        Design, develop, and implement complex mappings, sessions, and workflows using ETL processes using Informatica PowerCenter.

·        Identify the problems and Optimize ETL processes for maximum efficiency and performance through performance tuning.

·        Perform data analysis and data profiling to ensure data quality and integrity.

·        Must be able to use Informatica Data Quality tools.

·        Develop and maintain reusable data mappings, workflows, and sessions.

·        Proficiency in SQL and experience with relational databases (Oracle, SQL Server) with Strong SQL skills for data extraction, transformation, and loading.

·        Should have experience with data warehousing concepts and techniques.

·        Must have Knowledge of data modeling and data architecture principles.

·        Knowledge of big data technologies (Hadoop, Spark, Cloudera).

·        Troubleshoot and resolve data issues and ETL process failures.

·        Implement error handling and recovery strategies in ETL processes.

·        Collaborate with business analysts, data architects, and other stakeholders to understand business requirements and translate them into technical solutions.

·        Must be able to create detailed requirement documentations like FSD, SDD, TDD, Test Cases, Data Mappings for the requirements to develop and maintain proper versioning.

·        Ensure compliance with data governance and security policies, data masking, encryption.

·        Participate in code reviews and provide constructive feedback to peers.

·        Adhere to coding standards and best practices.

·        Stay updated with the latest developments in Informatica and data integration technologies.

·        Ability to work on Service tickets and provide resolution of production issues within defined SLA.

·        Ability to manage more than one application as primary and secondary owner.

·        Ability to analyze the problems and provide Root Cause Analysis for the incidents and implement the same.

·        Proactively check the server status and make sure the applications / systems are 100% up and running and available for users.

·        Adhere audit, lean, ISG and other procedure defined in the organization.

·        Ability to understand the business requirement and translate it into technical specification and implementation.

·        Planning and estimation for the projects, change requests etc. and tracking the same.

·        Prototyping and researching alternative implementation strategies.

·        Reporting daily call status to Team leads.

·        Getting the inspections/reviews done as per the plan.

·        Review/verify production transfer documentation, SOPs back up and roll back plans.

·        Lead the development actives in coordination with Vendor for vendor base application and endure all the deliveries are as per technology requirement.

·        Deploy bug fixes in test environment and perform SIT.

·        Ability to multi-task in a dynamic work environment.

·        Ability to develop large scale application implementations.

·        Ability to complete all phases of software development life cycle including analysis, design, functionality, testing and support.

Operating Environment, Framework and Boundaries, Working Relationships

·        Co-ordinates with members and other functional teams for his or team’s tasks

·        Work with team members participating in back up and training activities.

·        Adhere to information controls and security frameworks/procedures.

·        Provide general administrative support to the team, including, meetings, knowledge transfer and Timesheet reporting, preparation of weekly status report.

Problem Solving Skills

·        Ability to break down complex issues and identify most important and relevant information and options.

·        Ability to present and discuss problems with others toward permanent solution.

·        Investigate and understand the cause of defects raised.

·        Interpret, understand, and resolve user support issues.

·        Ability to perform root cause analysis.

·        Recommend solutions to system or process obstacles.

Decision Making Authority & Responsibility

·        Responsible to design functional solutions to business requirements.

·        Use effective judgment to weigh different options for achieving better results within appropriate timeframes.

·        Highlight any concerns affecting workplace deliverables.

Contact #8825984917

Send your resume to hr@marsdata.in