Procom Consultants Group
DBA/ETL Consultant
Procom Consultants Group, Bala Cynwyd, Pennsylvania, United States, 19004
Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada.
With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and is now the largest “Canadian-Owned” IT staffing/consulting company.
Procom’s areas of staffing expertise include:
Application DevelopmentProject ManagementQuality AssuranceBusiness/Systems AnalysisDatawarehouse & Business IntelligenceInfrastructure & Network ServicesRisk Management & ComplianceBusiness Continuity & Disaster RecoverySecurity & Privacy
Specialties:Contract Staffing (Staff Augmentation)Permanent Placement (Staff Augmentation)ICAP (Contractor Payroll)Flextrack (Vendor Management System)Job Description
DBA/ETL ConsultantOn behalf of our client, Procom Services is searching for a DBA/ETL Consultant for a contract opportunity in Bala Cynwyd, PA.Put your extract, transform, and load (ETL) skill set to work by overseeing highly complex ETL coding using software solutions such as Informatica and MS SQL server, closely adhering to deadlines. As Informatica Administrator, you will conduct peer reviews, and help prepare technical documentation, creation and maintenance of operational data store (ODS), data warehouse, and data mart applications. You will also coordinate builds and deployments across environments, and perform admin work as necessary.Key Responsibilities:Manage Development, QA, and Production environments.Ensure code synchronization across all three environments.Install patches (Hot Fixes/Software).Conduct bouncing activities or restart services as necessary.Monitor loads (workflows) to ensure they are scheduled to respective timings.Recover or restart loads in case of any failures.Identify tardiness in the loading process in case of any sessions are in hung status.DBA/ETL Consultant Mandatory Skills:Minimum of 4 years of overall IT experience.2 years prior experience focused in ETL design, development, review, and testing.2 years professional experience in Data Integration/Data warehouse environments.4 years of experience with Informatica PowerCenter.2 years professional development experience in SQL Server 2005, 2008, or 2012.Development experience in transforming XML messages and understanding of XML schemas.Integration experience with source code repositories (Subversion, Team Foundation Server).Experience working with offshore resources.Experience working with vendors.More than 2 years of experience in data warehouse/mart environments.Experience building/implementing scalable, reliable, and high-performance ETL architectures.Understanding of modern software engineering principles, practices, and systems development methodologies.Excellent ETL design skills and hands-on experience in developing ETL mappings.Hands-on experience in Informatica administration work.Demonstrated experience in optimizing/troubleshooting poorly performing ETL mappings.Working experience with the insurance industry is a plus.Professional experience with SAP Data Integrator as a designer and developer is a plus.Strong knowledge of data governance and data management concepts and practices.Strong knowledge of concepts and best practices for ETL development.High proficiency in understanding relational data models.Advanced knowledge of XML, XSLT.Strong knowledge of unit testing frameworks and SOAPUI.ASAP12 monthsAdditional Information
All your information will be kept confidential according to EEO guidelines. Please send your resume in
Word
format only.
#J-18808-Ljbffr
With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and is now the largest “Canadian-Owned” IT staffing/consulting company.
Procom’s areas of staffing expertise include:
Application DevelopmentProject ManagementQuality AssuranceBusiness/Systems AnalysisDatawarehouse & Business IntelligenceInfrastructure & Network ServicesRisk Management & ComplianceBusiness Continuity & Disaster RecoverySecurity & Privacy
Specialties:Contract Staffing (Staff Augmentation)Permanent Placement (Staff Augmentation)ICAP (Contractor Payroll)Flextrack (Vendor Management System)Job Description
DBA/ETL ConsultantOn behalf of our client, Procom Services is searching for a DBA/ETL Consultant for a contract opportunity in Bala Cynwyd, PA.Put your extract, transform, and load (ETL) skill set to work by overseeing highly complex ETL coding using software solutions such as Informatica and MS SQL server, closely adhering to deadlines. As Informatica Administrator, you will conduct peer reviews, and help prepare technical documentation, creation and maintenance of operational data store (ODS), data warehouse, and data mart applications. You will also coordinate builds and deployments across environments, and perform admin work as necessary.Key Responsibilities:Manage Development, QA, and Production environments.Ensure code synchronization across all three environments.Install patches (Hot Fixes/Software).Conduct bouncing activities or restart services as necessary.Monitor loads (workflows) to ensure they are scheduled to respective timings.Recover or restart loads in case of any failures.Identify tardiness in the loading process in case of any sessions are in hung status.DBA/ETL Consultant Mandatory Skills:Minimum of 4 years of overall IT experience.2 years prior experience focused in ETL design, development, review, and testing.2 years professional experience in Data Integration/Data warehouse environments.4 years of experience with Informatica PowerCenter.2 years professional development experience in SQL Server 2005, 2008, or 2012.Development experience in transforming XML messages and understanding of XML schemas.Integration experience with source code repositories (Subversion, Team Foundation Server).Experience working with offshore resources.Experience working with vendors.More than 2 years of experience in data warehouse/mart environments.Experience building/implementing scalable, reliable, and high-performance ETL architectures.Understanding of modern software engineering principles, practices, and systems development methodologies.Excellent ETL design skills and hands-on experience in developing ETL mappings.Hands-on experience in Informatica administration work.Demonstrated experience in optimizing/troubleshooting poorly performing ETL mappings.Working experience with the insurance industry is a plus.Professional experience with SAP Data Integrator as a designer and developer is a plus.Strong knowledge of data governance and data management concepts and practices.Strong knowledge of concepts and best practices for ETL development.High proficiency in understanding relational data models.Advanced knowledge of XML, XSLT.Strong knowledge of unit testing frameworks and SOAPUI.ASAP12 monthsAdditional Information
All your information will be kept confidential according to EEO guidelines. Please send your resume in
Word
format only.
#J-18808-Ljbffr