Work closely with clients to analyze, design, code, develop and upgrade database as per the business needs. Design and write technical specifications to design and develop database ETL (extract, transform and load) processes. Provide strategic direction and technical management consultation to client. Perform overall project analysis, architecture, design, development and implementation of Data Warehousing initiatives. Work on data warehousing projects from inception to implementation and deliver high quality solutions in a timely manner meeting and exceeding the business requirements. Work with the top management and executives, business sponsors and IT department to develop database, data warehouse and business intelligence solutions. Define information architecture and technology infrastructure along with the design of multi-dimensional data models and the business intelligence delivery solutions. Manage the data analysis, data sources, data mapping along with defining the Meta data repository. Manage the evolution of ETL and OLAP tools and recommend the most suitable solutions depending on business needs. Implement Informatica mappings to migrate source data to target after cleansing the data as per the requirements. Create Mapplets, Mappings, reusable transformations and sessions in Informatica. Extract data from various heterogeneous sources like DB2, Siebel and Flat Files using Informatica PowerCenter and loaded data in target database. Implement Unix shell scripts to automate the end-end bulk data processing to minimize the manual intervention. Perform unit testing and involved in closing the issues as part of system and integration testing. Updated the JIRA with proper root cause analysis and got the sign-off from testing teams and all business stakeholders. Work on fine tuning the existing jobs without impacting the business logic. Interpret the transformation rules for all target data objects and develop the software components to support the transformation. Provide metrics to measure progress and accuracy of data transfers. Automate ETL process through scheduling and exception-handling routines as well as source to target mapping development, support and maintenance. Responsible for ETL processes and tools as well as database loading and manipulation. Use OLAP (Online Analytical Processing), Oracle RDBMS, Informatica, DB2, Tableau, DataStage, and PL/SQL.
Job requirements: Master or its foreign equivalent degree in Computer Science, Computer Engineering, Computer Applications, Software Development, or Data Science. 24 months of experience in the job offered or in a related occupation as Database Administrator, Data Analyst, Software Engineer, or Application Development Team Lead. The 24 months of required work experience must include experience with Mapplet, Flat file, DB2, Informatica, Unix Shell Scripts, ETL and JIRA. Any suitable combination of education, training or experience is acceptable.
Job location: Various unanticipated client sites throughout the U.S., thus, travel and/or relocation to the client site is required.
Please email your application with case number of A-30-90, to: [email protected]