Role: *** 2 Informatica ETL DevelopersLocation: *** North Chicago, ILDuration: *** + month contract Or Contract to hireNote: Need local to Chicago are and who can come on our W2
Role Details: You will be responsible for designing and implementing efficient, flexible, extensible, and scalable ETL designs of medium to high complexity in an Enterprise environment. This includes data modeling, metadata analysis, in-depth understanding of the Informatica PowerCenter ETL and Data Transformation Tools and administering the Informatica PowerCenter platform. The candidate must be highly proficient and experienced at designing, implementing, and supporting ETL solutions data warehouse environment. Ideal candidate must be able to handle multiple highly complex projects concurrently and collaboratively in an Agile environment.Responsibilities:• Participates in collaborating with business partners to transform business requirements into environment specific ETL and data validation designs• Strong working knowledge across the technology stack including ETL, data analysis, metadata, data quality, audit and design• Technologies currently used and supported are: SQL Server Database, Business Objects, Crystal, Informatica PowerCenter, Informatica Metadata Manager, and CA Erwin• Design and develop ETL processes that load data for multitude of business processes such as Data Warehouse• Follow change management process to resolve application defects or to implement development enhancements• Responsible for Enterprise Data integration architecture/design & approach around data movement• Assist with the management of ETL scalability and system management.• Provide assistance with ETL design, development, and performance tuning• Design and architect ETL solutions as part of a cross-functional team• Coordinate and lead onsite and offshore delivery for team of 3-5• Design of data mappings, data movement routines & jobs in data management space• Responsible for design and development of data transformation objects, Technical Specifications, and Transformation rules• Plays a major role in Enterprise Data quality initiatives and supports Data Governance implementations• Analysis/Design of Data service routines that would source data from various enterprise data sources• Responsible for identifying/enhancing/implementing industry best practices in information Management space• Perform daily monitoring and support of all data load jobs• Address data related problems in regards to systems integration, compatibility, and multiple-platform integration• Supports existing data integration enhancements and jobs in an ongoing basis• Provide level-3 production support for data warehouse jobs on a rotational basisRequired skills:• Minimum 1-2 years’ experience in Informatica Data Transformation• Strong RDBMS DB development experience (Stored Procedure Development, Physical DB Object creation etc.)• Strong working knowledge across the technology stack including ETL, data analysis, metadata, data quality, audit and design.• Experience or exposure to Informatica Metadata Manager, SAP Business Objects & Crystal, Tableau, Hadoop, and CA Erwin.Required Technical Skills:• Platforms: MS Windows• Database Management Systems: Microsoft SQL Server *** • Data integration: Informatica PowerCenter ETL and Data Transformation• BI Reporting: SAP Business Objects & Tableau• Job Scheduling: SMA Solutions OpCon• File Movement: GO Anywhere Managed File Transfer• Experience working with SharePoint• Agile Development – Scrum Training• MS-Office/Visio• Bachelor’s degree with 5+ years of experience as a Developer for the Informatica Product Suite• Experience with Informatica B2B, PowerCenter, and Metadata Manager• Exposure to Informatica Administration• Experience using API’s with Informatica• Strong Data Modeling skills• Ability to work independently with business to gather requirements, provide solutions,• Experience integrating additional external sources like excel, csv, and pdf to the existing warehouse• Experience working on Informatica B2B using DX console or real time file processing• Excellent communication and analytical skills• Financial services is a plus
if you are intersted please share your updated resumes to [CONTACT] or *** *111
