BlueCloud
Associate Informatica / ETL Developer (India)
BlueCloud, Chicago, Illinois, United States, 60290
We are looking for a candidate to provide Informatica PowerCenter development and production support, with at least 2 years of Informatica Center experience. Nice to have skills include: Data Quality (IDQ), IICS, Control M, SSMS expertise to design and build solutions for our clients. Responsibilities Independently plan, design, develop, execute, and monitor complex data integration activities to support project delivery and daily operations. Define, implement, debug, and optimize data integration mappings and scripts from various data sources. Develop ETL code, metadata, queries, scripts, schedules, work processes, and maintenance procedures; identify opportunities to optimize performance and efficiency. Perform unit testing, system integration testing, regression testing, and assist with user acceptance testing. Consult with business stakeholders to develop documentation and communication materials for accurate data interpretation. Develop technical understanding of data flow from source systems to fine-tune data integration solutions. Work independently or as part of a team to deliver data warehouse ETL projects. Adhere to established standards and best practices, and contribute to process improvements. Maintain a high-volume data warehouse application. Manage multiple tasks simultaneously, switching between conflicting priorities. Experience and Education At least 2+ years of relevant experience. Bachelor's or Master's degree in Computer Science or Information Systems from a reputed university. Strong fundamentals in computer science. Excellent communication skills with business stakeholders. Strong technical, analytical, and organizational skills. Effective written and verbal communication, including technical writing. Technical Skills & Competencies Hands-on experience with commercial integration products including: PowerCenter 10.x (REQUIRED) Data Integration Hub (nice to have) PowerExchange (nice to have) Informatica Cloud (nice to have) Data Quality (nice to have) Go Anywhere (nice to have) Experience in Windows PowerShell / UNIX Shell Scripting, Control-M for job automation. Basic MSSQL Server development experience: stored procedures, explain plans, constraints, views, materialized views, export/import utilities. Knowledge of SDLC processes, performance tuning of sources, targets, mappings, and sessions. Azure Data Factory experience is a plus. Support skills: ability to identify critical system issues, manage user and object access, handle code migration, and coordinate Sev1 tickets. Maintaining standards: experience in following and enforcing coding standards, ensuring synchronization across environments, and supporting development team adherence. #J-18808-Ljbffr