Etl Consultant

Location: Burbank, CA(100% remote)
Duration: 6+ months
1. Informatica Developer - Level 3
Experience Required: 5-7 years/Candidate Rate - Max $75
• 5+ yrs. of Developer Experience in Informatica IICS Application Integration and Data Integration.
• Experience in PowerCenter along with IICS and complete knowledge of SDLC Process
• Experience in API development, including best practices, testing methods and deployment strategies.
• Experience in designing, creating, refining, deploying, and managing the organization's data Clienthitecture including the end-to-end vision for how data will flow from system to system, for multiple applications and across different territory.
• Expertise in with the tools like SOA, ETL, ERP, XML etc
• Understanding of Python, AWS Redshift, Snowflake and Relational Databases
• Knowledge of UNIX Shell scripts and should be able to write/debug Shell Scripts.
• Ability to work well within an agile team environment and applying the related working methods.
• Able to analyze and understand complex customer scenario's and thrives on difficult challenges
• Team player, multitasker, excellent communication skills (convey highly technical information into business terms, clear email communications), ability to mentor team members.
2. ETL Integration engineer - Level 4 / Candidate Rate - Max $75
Experience Required: 7-10 years
• 7+ years of experience as an ETL/Integration developer/engineer/Clienthitect
• 5 years of experience working with Informatica Repository, Designer, Workflow, and Monitor.
• 3+ years of programming experience in writing Linux and Shell scripts
• 3 years of experience setting up, monitoring, and troubleshooting PowerCenter for SAP Netweaver and SAP IDocs
• Experience in the extraction of SAP data sources using different integration methods
• Experience in Informatica Intelligent Cloud Services like Cloud Data Integration, Cloud Application Integration, API Management, Cloud Integration Hub Experience in Cloud API Gateway configuration
• Experience in integration of on-premise applications with SaaS applications
• Experience integrating ERP applications such as SAP, Salesforce, etc.
• Expertise in translating business requirements to project design, development, and execution
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Ability to communicate capabilities, opportunities, and recommendations to both technical and non-technical audiences
• A bachelor's degree in Computer Science, Engineering or equivalent work experience.
• Knowledge of large-scale application Clienthitecture, design, implementation and performance tuning.
• Experience in modern DevOps/SRE practices such as CI/CD, performance monitoring & incident management
3. Application Clienthitect(Redwood) - Level 3 /Candidate Rate - Max $85
Clienth Experience Required: 5-7 years
• Migrating the jobs from other batch scheduling tools to Redwood
• Scheduling job and job chains with time window and submit frames.
• Creating Jobs and scheduling jobs as per client requirement.
• Creation of Submit frames and time windows in Redwood as per client requirement.
• Monitoring and maintaining Redwood Housekeeping activities.
• Handling of jobs in various statuses like pending, cancelling, killing etc..,.
• Preparing weekly reports for Held jobs, Long Running and Error jobs.
• Running jobs and chains on ad-hoc request.
• Performing Iteration testing for jobs in DEV, QUA and PRD.
• Creation of Jobs, Job chains, Time Windows, Submit Frames, Events, Locks and Alert.
• Handling Alert Mechanism throughout SAP Redwood Landscape
• Performing regular System Health Checks.
• Monitoring Process Server and Queues.
• Handling Operator Messages.
• Performing maintenance activity.
• Preparing Issue Tracker and Incident Report and Publish Weekly Status Report.
• Review Strategy of Background (Batch) Jobs Setup and assess the current situation Schedule Jobs in SAP Redwood / Knowledge of Operating, Export / Import of jobs in Redwood.
• Configuring E-mail service in Redwood CPS.
• Development/Implementation experience in SAP Redwood/CPS.
• Creating Dependences in between jobs.
• Configuring Process Servers and Queues to manage entire Redwood system.
• Creating reports through Redwood
• Good knowledge in UNIX Shell scripts and should be able to write/debug Shell Scripts.
• Working well within an agile team environment and applying the related working methods.
• Able to analyze and understand complex customer scenario's and thrives on difficult challenges
• Co-ordinate with different teams across WBD landscape and come up with solution and fast track the priority issues.
• Basic Knowledge of Java and Scripting Preferable
4. Data Analytics Analyst - Level 4/ Candidate Rate - Max $75
Experience Required: 7-10 years
• Bachelor's degree in computer science, Information Technology, or a related field
• 7+ years of experience as an Clienthitect
• 5 years of experience implementing ClientM solutions
• Proven experience in designing and implementing ClientM solutions in an enterprise environment.
• Strong knowledge of ClientM platforms and technologies (e.g., Reltio ClientM, Informatica ClientM, SAP Master Data Governance).
• Understanding of data modeling, data integration, and data quality best practices.
• Familiarity with data governance frameworks and methodologies.
• Expertise in creating mappings, trust and validation rules, match & merge process.
• Experience in creating and maintaining entity objects, hierClienthies, entity types and relationship objects
• Excellent analytical, problem-solving, and communication skills.
• Own the logical unit of development work "end-to-end" from concept to production, covering each phase of the SDLC.
• Strong project management skills and the ability to lead cross-functional teams.
• Relevant certifications in ClientM or data management are a plus.