Job Summary: 

• Develop Informatica tools, Informatica Power Center, Informatica Cloud and other tools
• Develop ETL workflows using Informatica for data loads from source to target databases
• Determine appropriate translations between source and target, capture metadata, load and transform data from data sources into the target
• Design and implement appropriate error-handling procedures
• Monitor performance, troubleshoot and tune ETL processes
• Work closely with the architect and engineers to design systems that effectively reflect business needs, security requirements and service level requirements
• Research and investigate any Informatica issues
• Develop a deep understanding of the relationship between various business processes, systems, and the underlying data
• Create a mapping requirement document, ETL design documents, Unit Test cases, code repository and other relevant documents
• Coordinate with the application team and develop all ETL processes

Skills on Resume: 

• Informatica Tools (Hard Skills)
• ETL Workflows (Hard Skills)
• Data Transformation (Hard Skills)
• Error Handling (Hard Skills)
• Performance Tuning (Hard Skills)
• System Design (Soft Skills)
• Issue Troubleshooting (Hard Skills)
• Team Coordination (Soft Skills)

Job Summary: 

• Design, develop, and test data processes per business requirements, following the development standards and best practices
• Participate in code peer reviews to ensure applications comply with best practices
• Work with business analysts to gather business requirements from end users and translate them into technical specifications
• Gather requirements to define data definitions, transformation logic, and data model logical and physical designs, data flow, and process
• Responsible for providing technical guidance/solutions
• Provide estimates for development
• Perform data analysis and data profiling against source systems and the data warehouse
• Design data marts to support Business Intelligence reporting
• Design ETL processes using Informatica Power Center
• Assist developers with difficult Oracle PL/SQL code for queries, triggers, and stored procedures
• Design, develop, implement and maintain custom Oracle applications written in PL/SQL
• Conduct reviews of developed code
• Test solutions to validate whether requirements have been met
• Develop test plans, test scripts, and test conditions based on the business and system requirements
• Provide end-user support in post-deployment phases
• Assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addressed

Skills on Resume: 

• ETL Development (Hard Skills)
• Data Design (Hard Skills)
• Oracle PLSQL (Hard Skills)
• Code Review (Hard Skills)
• Data Profiling (Hard Skills)
• Requirement Analysis (Soft Skills)
• Solution Guidance (Soft Skills)
• User Support (Soft Skills)

Job Summary: 

• Contribute to the application and platform support of the EDW ecosystem through the development, testing, and implementation of availability, performance, security, currency, and problem remediation solutions
• Partner with the Product Owner, Engineering teams, and Operations to deliver a high-quality product by creating, developing, and testing solutions that are aligned with best practices within the SRE framework
• Maintain code quality, documentation, organization, and performance, meeting security, change, and release management standards, ensuring SRE targets are met or improved
• Identify opportunities, recommend, and implement solutions to improve data availability, optimize data retention, and enhance data security
• Identify opportunities for quality improvements, recommending and implementing automation to prevent problem recurrence and reduce toil
• Create and continuously improve functional and non-functional testing, ensuring tests are automated, repeatable, and benchmarked
• Inventory, build and maintain application artifacts, creating a robust repository of living documentation including application, deployment and operational guides
• Provide knowledgeable and skilled support for deployments and production incident response, striving to meet or exceed service level objectives
• Design, document and implement new ETL enhancements and modify existing code
• Work independently or with a team to develop, configure mappings (source to target mappings)
• Interaction with Relational data warehouse solutions such as Snowflake, Postgres, Microsoft SQL Server, Oracle database, etc.
• Understanding the clients/customers' requirements
• Deliberating on different viable options for implementing technical solutions to the customer's requirements
• Utilizing data monitoring tools to track the current status of ETL Pipelines for performance and completion

Skills on Resume: 

• ETL Enhancements (Hard Skills)
• Data Security (Hard Skills)
• Automation Design (Hard Skills)
• Code Quality (Hard Skills)
• Data Monitoring (Hard Skills)
• Requirement Analysis (Soft Skills)
• Problem Resolution (Soft Skills)
• Team Collaboration (Soft Skills)

Job Summary: 

• Design, develop, maintain, and test Data warehouse applications, collaborating with the development team, testing team and business partners to ensure successful delivery and implementation of the application
• Responsible for reviewing and understanding requirements and translating them into high-level and low-level documentation, including source-to-target mappings
• Responsible for building data mappings, sessions, and workflows to meet requirements (Informatica 9.x or above)
• Develop job schedules that integrate with upstream and downstream systems (AutoSys jobs)
• Responsible for the coordination of offshore development to assist in build efforts, including meeting with the offshore team daily to discuss ongoing work
• Responsible for unit testing, debugging, and performance testing, with a key focus on data accuracy and integrity
• Work with the production support teams to support production activities, including production migrations, L3 support, continuity testing, and environment migration activities
• Directly working with users/ LOB to understand their needs and address their clarifications
• Responsible for the application design, development, and implementation of the strategic architecture of data warehouses at an enterprise level
• Involved in strategic planning activities and research on emerging technology, tools, and ETL standards for use in existing or new data marts
• Work with various business units to recommend and develop system solutions to business problems and translate business requirements into technical specifications and applications
• Assist in the design, clarification of requirements, and development of data warehouse and ETL solutions

Skills on Resume: 

• ETL Development (Hard Skills)
• Data Mapping (Hard Skills)
• Workflow Design (Hard Skills)
• Job Scheduling (Hard Skills)
• Performance Testing (Hard Skills)
• Offshore Coordination (Soft Skills)
• Requirement Analysis (Soft Skills)
• Production Support (Soft Skills)

Job Summary: 

• Design, develop, unit test and maintain ETL jobs to create or enhance data warehousesmarts
• Design ETL via source-to-target mapping and design documents that consider security, performance tuning and other best practices
• Test ETL and other technical components and support QA activities
• Deploy and test code from lower environments to production
• Document technical specifications, data models, process flows, etc.
• Identify improvement areas and propose solutions for the same
• Understand the current application with minimal guidance
• Collaborate with delivery and technical team members on design and development activities within AgileScrum teams
• Collaborate with business partners to understand business processes, standard release management requirements, and underlying data and reporting needs
• Conduct data analysis in support of ETL development, issue analysis and resolution, and activities

Skills on Resume: 

• ETL Development (Hard Skills)
• Source Mapping (Hard Skills)
• Performance Tuning (Hard Skills)
• QA Support (Hard Skills)
• Technical Documentation (Hard Skills)
• Data Analysis (Hard Skills)
• Agile Collaboration (Soft Skills)
• Process Improvement (Soft Skills)

Job Summary: 

• Modify existing and build new IICS and PowerCenter Integrations
• Develop IICS Application Integration components like processes, service connectors and process objects
• Build service connectors for real-time integration with third-party applications
• Build Business Services using a JSON file to call web services
• Integrate Informatica Cloud with other applications like Salesforce, Workday, and ServiceNow
• Install add-on connectors and drivers for IICS
• Use methodologies for data extraction, transformation and loading data using various transformations like Expression, Router, Filter, Lookup, Update Strategy, Union, and Aggregator
• Build data integration processes by constructing mappings, tasks, taskflows, schedules, and parameter files
• Write scripts for file watching and file transfer protocols
• Create architectural patterns, best practices and guidelines for enterprise applications
• Collaborate on multiple concurrent projects and perform a variety of different roles in the software development life cycle
• Communicate project status with the leadership team

Skills on Resume: 

• IICS Development (Hard Skills)
• Real-Time Integration (Hard Skills)
• Web Services (Hard Skills)
• Cloud Integration (Hard Skills)
• ETL Transformations (Hard Skills)
• Data Mapping (Hard Skills)
• Scripting (Hard Skills)
• Project Collaboration (Soft Skills)

Job Summary: 

• Lead the support team and ensure that the application is running as per the SLA
• Communicate with stakeholders in case of delays or SLA breaches
• Maintain and own the defect management and incident resolution process
• Resolve defects within the defined service levels
• Manage and own the application's Defects and incident life cycle, and drive those to permanent resolutions, implement preventive measures to avoid repetitive issues
• Debug, troubleshoot, root cause analysis and resolve issues within SLA
• Resolve complex defects with long-term fixes following best practices and collaborate with the dev team for solution review of complex defects and incident resolution
• Follow up with third-party vendors for issue resolution and prevention
• Perform weekly incident/bug review meetings with the application team
• Responsible for 24/7 production system support, including off-hours and weekend 'on-call' production support responsibilities
• Daily spot check of system health
• Manage and own the application release process
• Follow the change control and continuous integration process for changes to the production system, owning all changes made to the production system
• Responsible for continued system improvements to help reduce tech debt costs
• Perform custom, ad-hoc data analysis and reporting based on stakeholder requests within SLA
• Support weekly and monthly customer report processing
• Conduct regular presentations to the team/stakeholders

Skills on Resume: 

• Team Leadership (Soft Skills)
• Stakeholder Communication (Soft Skills)
• Defect Management (Hard Skills)
• Incident Resolution (Hard Skills)
• Root Cause Analysis (Hard Skills)
• Vendor Coordination (Soft Skills)
• Production Support (Hard Skills)
• System Improvement (Soft Skills)

Job Summary: 

• Responsible for full life cycle software development including new development, design/architecture, and implementation using Informatica Power Center 2.0.
• Designs and develops high-quality integration solutions consistent with given requirements
• Drives project and technology goals in line with organizational objectives
• Partners with departmental management to develop strategic/tactical solutions to support business strategies
• Develops and establishes departmental technical standards and procedures
• Responsible for requirement gathering, analysis and documentation
• Responsible for reviewing design and all project-related deliverables to ensure adherence to standards and best practices
• Responsible for making sure the requirements are defined and properly documented
• Responsible for ensuring the final application meets the defined functional requirements
• Coordinate with other Client business user groups and subject matter experts directly
• Design and implement high-performance, scalable and optimized data solutions on top of terabytes of highly valuable data sets
• Manage and improve the existing code base and add new features to support business needs
• Support and troubleshoot data and/or system issues
• Work collaboratively with smart, diverse and fast-growing teams to rapidly deliver high-quality solutions
• Mentoring the technical development team on optimal utilization of Big Data solutions and Apache Open Source Software
• Leading a high-performance team of core big data framework developers in areas of data ingestion, data distribution, data enrichment, etc.
• Work in a Global delivery environment, engaging with teams in an onsite/offshore model

Skills on Resume: 

• ETL Development (Hard Skills)
• Solution Design (Hard Skills)
• Requirement Analysis (Soft Skills)
• Standards Compliance (Hard Skills)
• Data Solutions (Hard Skills)
• System Troubleshooting (Hard Skills)
• Team Mentoring (Soft Skills)
• Global Collaboration (Soft Skills)

Job Summary: 

• Develop ETL scripts using Informatica Power Center to migrate data from Oracle into a Snowflake data lake
• Assist with designing and developing data integration and engineering workflows
• Support general ETL activities including building end-to-end ETL processes for a variety of structured, semi-structured, and unstructured data sources using tools such as Informatica, Snowflake, and others
• Assists with the creation of documentation of functional requirements for business systems applications, including the budget development, planning, and monitoring processes
• Analyzes, develops, and evaluates data in a data warehouse environment including data design, database architecture, metadata, and repository creation
• Performs the translation of functional specifications into detailed technical system designs
• Works with System Administrators, Database Administrators, and the Quality Assurance Center of Excellence to test and tune development efforts
• Ensures that current and future systems that are planned, developed or procured meet Board standards and are compatible
• Collaborate with the team, business and other technical groups
• Develop and deliver ETL applications using Informatica PowerCenter
• Develop routines for ETL performance optimization
• Develop scripts in SQL, Unix

Skills on Resume: 

• ETL Development (Hard Skills)
• Data Integration (Hard Skills)
• Snowflake Development (Hard Skills)
• Data Architecture (Hard Skills)
• System Design (Hard Skills)
• Performance Optimization (Hard Skills)
• SQL Unix (Hard Skills)
• Team Collaboration (Soft Skills)