• Develop integrations between various source systems to Oracle database tables using ETL tools
• Provide technical advice on ETL design and programming for new projects or change requests
• Provide support on existing ETL jobs developed
• Provide development work on OBIEE based on the report and metadata definition
• Perform unit and integration tests, and support UAT testing in accordance with project methodologies and policies
• Support the team in analyzing and documenting project requirements through reviewing ETL source codes of other similar projects and managing the releases of related builds in different environments
• Perform development, documentation, debugging and implementation of solutions for Informatica ETL requirements
• Deliver low-level design documents with ETL and DWH strategy, standards and adhere to ETL and BIW principles and policies
• Accountable for any development and build-related queries/issues
• SQL performance tuning, relational model analysis and data migration
• Design an end-to-end ETL solution for complex case studies

Skills: ETL Development, SQL Tuning, Data Migration, OBIEE Reports, Unit Testing, UAT Support, Requirement Analysis, Solution Design

• Design, create and support objects in Informatica PowerCenter using an Oracle database
• Interface with the user community to collect and document requirements for various projects
• Adhere to architecture standards, risk management and security policies
• Provide presentations in architecture review, strategic technology directions, and best practice development (e.g., estimating models)
• Responsible for the design, build and maintenance of software applications for Chase Card Services Data Warehouse
• Design, analyse, develop, code, test, debug, and document programming to satisfy business requirements
• Deliver the assigned work within specified timelines with high quality
• Participate in every phase of the software delivery life cycle, including requirements, Analysis and Design, Build Code, Unit testing, Support system integration testing, Implementation phase and post-implementation support
• Write and enhance technical specifications based on functional specifications
• Produce unit test case results, Implementation plans, Application Support Guide using Word, Excel, PowerPoint, Visio
• Develop code using Informatica, Oracle, Unix (Korn Shell scripts), PL/SQL, Scheduling tools like Control-M, Java, and Kafka
• Perform unit testing, ensuring minimal code defects out of the build phase into the system test phase
• Identify and communicate potential impacts of a change/issue to other areas

Skills: Informatica PowerCenter, Oracle SQL, Unix Scripting, Data Warehousing, Control M, Java Development, Software Testing, Technical Documentation

• Work closely with Business Analysts and Architects to understand the business and technical features
• Review the Detailed Business Requirement Documents to understand the business conditions
• Identify the gaps in the source data and work with Data modelers/Architects to fix the gaps
• Design complex SQL scripts for Data profiling and analysis
• Document the mapping specs with detailed transformation rules and join conditions
• Review the mapping specs with the Business and technical teams for approval
• Work with the Coding and testing teams to resolve mapping-related questions
• Coordinate with Offshore teams and clarify their questions by discussing with Onsite POCs (Business and Technical Team)
• Loading cleansed data into Base Objects and running Match and Merge
• Configuring Match and Merge rules, Auto Merge, Threshold, Data Stewardship views, User setup, Customization, etc
• Implementing Enterprise Master Data Management for Customer, Product, Vendor, and Material Master

Skills: Business Analysis, Data Profiling, SQL Scripts, Mapping Specifications, ETL Development, Offshore Coordination, Match Merge, MDM Implementation

• Work under data/solution architects to deliver enterprise-class data structures and solutions and/or integration into custom product development
• Help define data matrices, data dictionaries, and data structures across various topologies (SQL Server 2016, Hadoop/Cloudera stacks, etc.)
• Complete product technical design and prototyping, data design/development, support and problem remediation
• Understand data design patterns and enterprise design regarding data in the Payments Industry (banking, credit unions, bill pay, EFT, etc.) within both commercial off-the-shelf (COTS) and custom solutions
• Experience around performance analysis at the Data/DAL layer and how to maximize performance in a highly transactional environment in the payments industry (cards, core banking, ATM, etc.)
• Provide both individual, team, and budget-level tasks and product effort estimates/costs and overall LOE regarding data efforts
• Document technical designs, using flow charts, class diagrams, sequence diagrams, activity diagrams, data flow diagrams, database schemas, descriptive software component documentation, and wireframes
• Develop and test applications based on business requirements and industry best practices
• Creates technical documentation, use cases, white papers, system and deployment architecture, and technical process/procedure documents for the group
• Adheres to documented departmental and corporate standards
• Participates in the definition and documentation of standards
• Assess the risk, problem/problem resolution and impact of changes to complex solutions and the effect of hardware infrastructure change on a solution or technology
• Reviews, coordinates, analyses and defines requirements for new development/enhancements
• Maintains existing systems including new product development, customizations and enhancements

Skills: Data Structures, Data Dictionaries, Technical Design, Data Modeling, Performance Analysis, Effort Estimation, Application Development, Technical Documentation

• Prepares detailed technical specifications from which complex data integration programs will be written or configured using the Informatica suite of products
• Writes high-quality code using the Informatica suite of products, and according to specifications
• Defines or may assist others in defining application system scope and objectives through research and fact-finding
• Builds mechanisms and reports exception feedback loops into the data integration processes
• Conducts appropriate functional and performance testing to identify bottlenecks and data quality issues
• Provides technical direction in the maintenance and development of the extract, transform and load (ETL) aspects of the data warehouse
• Maintains an understanding of the inputs received from the data source providers
• Performs analysis, design, development, and implementation of new ETL requirements
• Recommends changes to enhance the data warehouse data cleansing and conversion processes
• Supports testing and validation of the new data conversion processes
• Responsible for planning and monitoring the schedule, milestones and deliverables for assignments
• Manages appropriate levels of systems documentation

Skills: Technical Specifications, Informatica Development, ETL Processes, Data Testing, Performance Tuning, Data Analysis, SDLC Experience, Systems Documentation

• Hands-on experiences on ETL, like Informatica, SSIS and Kettle
• Solid knowledge of SQL Scripting and database (e.g., Oracle, SQL Server)
• Strong understanding of data warehousing concepts (fact, dimension, data model, star schema, etc.)
• Ability to analyze existing ETL, SP, and provide an as-is analysis report
• Familiar with the software development life cycle
• Capability in drafting the requirement/design document
• Professional team player with good communication skills
• Familiar with Python/Spark/AWS
• Working experience in ETL and SQL
• Working experience in Python/Spark/AWS 

Qualifications: BA in Economics with 3 years of Experience

• Good experience and knowledge working with Informatica PowerCenter
• Experience in working on Informatica Cloud IICS - Data Integration
• Work experience and knowledge of Unix and shell scripting
• Knowledge on Cloud Application Integration
• Knowledge of working in the Google Cloud platform
• Ability to interact with SME for requirement gathering
• Ability to create solution Architecture for different ETL use cases
• Ability to review existing system Architecture, find out the gaps and suggest customer the best possible solution
• Ability to mentor Junior resources and drive training/knowledge sharing sessions
• Experience in working on premise and cloud databases and data warehouses
• Proficient in SQL and data warehousing concepts
• Must have good analytical skills
• Good at documenting requirements, impact analysis

Qualifications: BA in Management Information Systems with 6 years of Experience

• Good understanding and working experience in Informatica MDM 10.2 and experience in upgrading the MDM project 
• Solid Informatica MDM core knowledge (Hub configurations, IDD and E360 configurations)
• Experience in configuration of provisioning tool, building custom external business entity services
• Good knowledge of ActiveVOS and ActiveVOS custom workflows
• Expert in the MDM Informatica tool
• Good PL/SQL knowledge to write and execute the queries
• Experience in Informatica ETL development
• Experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes
• Experience working with complex SQL
• Must have outstanding analytical, interpersonal, written, and oral communication skills

Qualifications: BA in Business Analytics with 4 years of Experience

• In-depth hands-on Experience with Informatica ETL tool, Unix scripting and automation
• In-depth SQL skills with MS-SQL 2016 and Oracle 12C
• Experience coding complex stored procedures, Packages and Triggers for application in Oracle and MS-SQL
• Proficient in Unix/Linux shell scripting for job automation and exposure to scheduling tools like IBM-Tivoli
• Strong data analysis skills (utilize DB tools, SQL, explain issues clearly, offer solutions and options for issues encountered)
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
• Understanding of Data warehousing concepts and Reporting Environment
• Good to have exposure to JSON string and Web Api application-related Understanding
• Agile project development experience and offshore-onshore working model
• Highly effective working in a team, as well as working independently
• In-depth knowledge and hands-on experience with Informatica PowerCenter Transformation
• In-depth knowledge of Push-down optimization
• Able to manage, administrate and maintain Informatica Infrastructure, including Informatica PowerCenter repositories

Qualifications: BS in Applied Mathematics with 6 years of Experience

• Strong working experience in Informatica PowerCenter, SQL Server, SQL and Python or Unix
• Must have extensively worked in developing an ETL program for supporting Data Extraction, transformations and loading using Informatica PowerCenter
• Good experience in creating Transformations and mappings using Informatica Designer
• Very good knowledge of SQL Server, PL/SQL
• Very good skills in Python or UNIX
• Able to analyze/create Python or UNIX scripts individually
• Good knowledge of ETL process, standards, and best practices
• Hands-on experience in Batch processing and SQL Programming/Querying (Stored procedures, Functions, Complex joins, Triggers, Indexing, DML and DDL)
• Able to individually attend client calls and perform requirement gathering and prepare documents
• Good at debugging and analyzing issues and resolving them promptly

Qualifications: BA in Information Systems with 5 years of Experience