Please find a short description of our excellent
Please mail me requirements Kri...@dconinc.com
or you can reach me @ 469 640 2180
Name: SNJ, Location: Birmingham, Alabama 35205, Relocation: Open, Visa: H1B, Availability: Immediate, Comm Skills: V Good.
· Around 8 plus years of extensive experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and developing Master Data using Informatica PowerCenter / IDQ, Teradata,Datastage, SQL, PL/SQL, and, Unix, shell scripting.
· Created mappings in mapping Designer to load data from various sources using transformations like Transaction Control, Lookup (Connected and Un-connected), Router, Filter, Expression, Aggregator, Joiner and Update Strategy, SQL, Stored Procedure and more.
· Worked on Informatica Data Quality (IDQ) tool kit and performed data profiling, cleansing and
· Good knowledge on data quality measurement using IDQ and IDE
· Have experience of working on Informatica MDM to design, develop, test and review , optimize Informatica MDM.
· Wrapper developed in python for instanting multi-threaded applications and running with other applications
· Managed the Informatica Data quality (IDQ)/CDQ and collaborated with MHE Data Owners, Operational Data Agents, Process Owners, Policy owners and Subject Matter Experts.
· Generated data quality reports and notifications to identify critical gaps for business process improvements.
· ETL developer, Infa admin and MFT developer for prudential client.
· Along with Infa admin activities and MFT focal point of contact for business users and integration teams.
· Creation of B2B DX partners, profiles, workflows, endpoints for Onboarding clients.
· Working on Proof of Concepts to come up with possibilities of implementing Informatica B2B DT studio.
· Worked on projects involving the creation of Sequence DataWarehouse. The Data Warehouse captures data from Prudential’s customers and transformations database maintained under client serverarchitecture.
· More than 5 years of Informatica Intelligent Data Management (IDMC) / Informatica Intelligent Cloud Services (IICS)
· Relationship types using hierarchy tool to enable HM in MDM implementation
· Designed, Installed, configured core Informatica/Siperian MDM Hub components such as Informatica Hub Console.
· Expertise in extraction, Transformation, loading data from Oracle, DB2 and SQL server using informatica and Talend.
· processing work flows and trouble shooting for mainframe and open system platform
· Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines
Technical
Skills:
|
Programming Languages |
Python, SQL, PL/SQL, Oracle |
|
Libraries |
TensorFlow, Pytorch, NumPy, Pandas, Sickit-Learn, Mongo DB |
|
Technologies |
ETL- Extract Transform and Load , Autosys, Jira, Source Tree, Bitbucket and Enterprise Jenkins, Kafka, SAP Salesforce , Teradata, B2B, Oracle ODI,Enterprise Datawarehouse concepts, MS
SQL ServerCoud platforms like AWS, Azure OpenStack |
|
Other ETL Tools |
Informatica Power Center 10.1/9.6.1/9.5.1 and Informatica Data Quality (IDQ), IICS, Talend, MDM, SSIS and SSRS. |
|
Reporting Tools |
Tableau, PowerBI, SSRS |