| : Title: Informatica ETL Developer || Location: 100% Remote || Visa: USC and GC (Born USC will win here) at Remote, Remote, USA |
| Email: [email protected] |
| Hi, Hope you are doing great! Please find the requirement below , If you find yourself comfortable with the requirement please reply back with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number 302-485-1712 Title: Informatica ETL Developer Location: 100% Remote Visa: USC and GC (Born USC will win here) Duration: 12+ Months LinkedIn URL, SSN, DOB Need consultants from these states only - AR, AZ, DE, FL, GA, IA, IL, KS, KY, MD, ME, MI, MN, MO, ND, NE, OK, SD, TN, TX, VA, WI Mandatory Notes :- ICM NO LONGER REQUIRED **STILL LOOKING! ** Strong hands-on experience with Informatica PowerCenter. Strong experience with using SQL for data querying and manipulation. Not just an order taker but can bring ideas to the table and asks great questions. Clear and concise answers. Someone who rambles is an immediate red flag. Client has the Incentive Comp Management (ICM) platform within SAP that manages all of their Broker Commissions/Compensation. They have historically outsourced the management of this platform and their broker commissions to a third party who specializes in ICM. This partnership was owned by the business and so IT has little to no involvement in the past with comp management. They have had a continued pattern of issues with data quality and reporting inaccuracies which has led to significant issues and LOTs of not happy noise around broker commissions. They are subsequently bringing that ownership back in house to be managed internally by Client IT and will be transitioning away from outsourcing to 3rd party. However, there is a big lift to get them ready to deploy that capability in house: they need to re-validate the end capabilities and use cases for broker commissions and from there back end to an overall assessment/mapping/recommendation of how to get there. They have very little trust in their data quality, their data accessibility strategy will need to shift as they bring that in house, they need to map out the processes to help build out new SOPs/SLAs to be managed now internally, and then once all of that is validated and designed, they need to figure out how to deploy within ICM, build model for continued support. The Informatica ETL Developer is a key member of the data integration team, responsible for designing, implementing, and maintaining ETL processes to ensure the accurate and timely flow of data across various systems and databases. This role involves collaborating with business analysts, data architects, and other stakeholders to meet data integration requirements. Key Responsibilities: Requirements Analysis: Collaborate with business analysts and stakeholders to understand data integration requirements and translate them into technical specifications. ETL Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or similar tools to extract data from source systems, transform it according to business rules, and load it into target systems. Data Extraction: Extract data from diverse source systems, which may include databases, flat files, APIs, and other data sources. Data Transformation: Implement data transformations, cleansing, and enrichment processes to ensure data quality and alignment with business needs. Data Loading: Load transformed data into data warehouses, data marts, or other target systems, ensuring data consistency and accuracy. Performance Optimization: Optimize ETL processes for performance, scalability, and efficiency. Identify and resolve performance bottlenecks. Error Handling and Logging: Develop robust error handling mechanisms to capture, log, and manage ETL errors. Monitor and troubleshoot data integration issues. Data Quality and Validation: Implement data quality checks and validation routines to maintain data integrity and compliance with business rules and regulations. Documentation: Maintain detailed documentation of ETL processes, mappings, transformations, and configurations. Ensure documentation is up to date and accessible to team members. Testing and Quality Assurance: Create and execute test cases to validate ETL processes, ensuring data accuracy, completeness, and reliability. Deployment: Deploy ETL jobs to production environments and schedule them for regular execution. Coordinate with system administrators and other teams for deployment. Collaboration: Collaborate with data architects, database administrators, business analysts, and other stakeholders to understand data requirements and ensure seamless data integration. Security and Compliance: Ensure data integration processes adhere to security policies, data privacy regulations, and compliance standards. Version Control: Use version control systems to manage ETL code and configurations. Qualifications and Skills: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience). Strong experience with Informatica PowerCenter or other ETL tools. Proficiency in SQL for data querying and manipulation. Knowledge of data warehousing concepts and data modeling. Familiarity with databases (e.g., Oracle, SQL Server) and various data formats (e.g., CSV, XML, JSON). Problem-solving and troubleshooting skills. Attention to detail and commitment to data quality. Excellent communication and collaboration skills. Ability to work independently and as part of a team. Experience with performance tuning and optimization of ETL processes is a plus. Thanks And Regards Khokan Kaviraj Phone: 302-485-1712 Email: [email protected] Hangout: [email protected] Linked In: https://www.linkedin.com/in/khokan-kaviraj-582655166/ Accroid Inc. 1007 Orange ST 4th FL 1651 Wilmington, DE 19801 -- Keywords: information technology green card trade national Arizona Arkansas Delaware Florida Georgia Illinois Iowa Kansas Kentucky Maryland Michigan Minnesota Missouri Nebraska North Dakota South Dakota Tennessee Texas Virginia Wisconsin |
| [email protected] View all |
| Tue Feb 13 02:31:00 UTC 2024 |