Informatica etl developer jobs near me

W2 ONLY, Client CANNOT do Sponsorship Salesforce Developer Duration: Direct Hire We are seeking an experienced Salesforce Developer/Administrator to support, enhance, and optimize our Salesforce platform. This role will focus on designing and building scalable solutions using Apex, Lightning Components, Visualforce, API integrations, and standard Salesforce configuration. The ideal candidate is a hands-on Salesforce expert who can collaborate with business stakeholders, translate requirements into technical solutions, and ensure the platform operates efficiently and reliably. This is a remote position. Key Responsibilities Salesforce Development Design, develop, test, and deploy custom solutions using Apex classes, triggers, Lightning Web Components (LWC), Aura components, and Visualforce pages. Develop and maintain API integrations between Salesforce and external systems (REST/SOAP APIs). Build and optimize declarative functionality including flows, validation rules, process automation, and page layouts. Salesforce Administration Manage day-to-day Salesforce operations including user setup, permissions, roles, profiles, and security settings. Maintain and optimize objects, fields, workflows, approval processes, reports, and dashboards. Troubleshoot issues, provide user support, and ensure data integrity across the platform. System Enhancements & Projects Translate business requirements into Salesforce solutions through configuration or custom development. Participate in full SDLC processes including requirements gathering, technical design, development, testing, and deployment. Support Salesforce releases by testing new features, identifying impacts, and implementing updates. Collaboration & Documentation Work closely with stakeholders across Sales, Marketing, Customer Support, and IT to enhance Salesforce functionality. Create and maintain technical documentation, data flow diagrams, and system configuration records. Provide training and guidance on Salesforce best practices and new features. Qualifications 3+ years of hands-on Salesforce development and administration experience. Strong experience with: Apex (classes, triggers, batch jobs, schedulers) Lightning Web Components (LWC) and/or Aura Components Visualforce REST & SOAP APIs / integration patterns Proficiency in Object-Oriented Programming (OOP) concepts. Strong understanding of Salesforce data structures, security model, and declarative capabilities. Experience working in an Agile or iterative development environment. Salesforce certifications such as Platform Developer I/II, Admin, or App Builder are a plus. Key Competencies Strong problem-solving and troubleshooting skills Ability to communicate clearly to both technical and non-technical audiences Highly organized and able to manage multiple projects Self-driven and comfortable working remotely

This position is posted by Jobgether on behalf of a partner company. We are currently looking for an ETL Developer II in the United States. We are seeking a skilled ETL Developer II to design, enhance, and maintain robust data integration processes across internal systems. This fully remote role offers the opportunity to work closely with a small, collaborative team to ensure seamless data flow, accurate reporting, and reliable insights for decision-making. The ideal candidate will be responsible for building scalable ETL pipelines, working with APIs, and supporting business teams with efficient and automated data solutions. This position is critical to the development of data-centric tools that drive organizational success, while allowing autonomy, professional growth, and a strong work/life balance. Accountabilities Design, develop, and maintain ETL processes to support business functions and internal teams. Administer the ETL ecosystem, ensuring data accuracy, integrity, and optimal performance. Collaborate with stakeholders to understand business logic and deliver effective integration solutions. Generate reports and queries from databases to facilitate data-driven decision-making. Automate workflows and continuously improve processes for efficiency and reliability. Integrate data through APIs and other tools to support seamless information exchange. Troubleshoot and resolve issues in data pipelines to maintain smooth operations. Requirements 3+ years of experience with relational databases and SQL. Bachelor's degree in Computer Science, Information Systems, or related field. 3+ years of hands-on experience with ETL tools (e.g., Talend, SSIS, Informatica). Proficiency in Excel for data manipulation, reporting, and analysis. Experience with API testing tools (e.g., Postman) and data integrations. Familiarity with BI and reporting tools (e.g., Power BI, Tableau). Strong problem-solving, troubleshooting, and critical thinking skills. Excellent written and verbal communication skills to convey technical concepts to non-technical stakeholders. Preferred: Knowledge of data governance, cloud platforms (AWS, Azure, Google Cloud), and data quality best practices. Benefits Fully remote, work-from-home position. Generous paid time off and paid holidays. Annual bonus potential. Retirement savings plans with company support. Paid training and professional development opportunities. Career growth and advancement within a global organization. Supportive and collaborative work environment fostering diversity and inclusion. Jobgether is a Talent Matching Platform that partners with companies worldwide to efficiently connect top talent with the right opportunities through AI-driven job matching. When you apply, your profile goes through our AI-powered screening process designed to identify top talent efficiently and fairly. 🔍 Our AI evaluates your CV and LinkedIn profile thoroughly, analyzing your skills, experience, and achievements. 📊 It compares your profile to the job's core requirements and past success factors to determine your match score. 🎯 Based on this analysis, we automatically shortlist the 3 candidates with the highest match to the role. 🧠 When necessary, our human team may perform an additional manual review to ensure no strong profile is missed. The process is transparent, skills-based, and free of bias - focusing solely on your fit for the role. Once the shortlist is completed, we share it directly with the company that owns the job opening. The final decision and next steps (such as interviews or additional assessments) are then made by their internal hiring team. Thank you for your interest! #LI-CL1

Why Blue Coding? At Blue Coding, we specialize in hiring excellent developers and amazing people from all over Latin America and other parts of the world. For the past 11 years, we've helped cutting-edge companies in the United States and Canada build great development teams and develop great products. Large multinationals, digital agencies, Saas providers, and software consulting firms are just a few of our clients. Our team of over 150 engineers, project managers, QA, UX/UI designers, and many more is distributed in more than 10 countries across the Americas. We are a fully remote company working with a wide array of technologies, and we have expertise in every stage of the software development process. Our team is highly connected, united, and culturally diverse, and our collaborators are involved in many initiatives around the world, from wildlife preservation to volunteering at local charities. We stand for honesty, fairness, respect, efficiency, hard work, and cooperation. This position is open exclusively to candidates based in LATAM countries. What are we looking for? In this opportunity, we are looking for an ETL Developer to work with one of our foreign clients, a market leader in the consultation, design, procurement, implementation, and ongoing managed services for technology services for mid to large global enterprises. As a Telecom Managed Service company, they partner with over 300 service providers globally to help customers with technology design and find the best solutions to meet their needs. Our client is modernizing their data infrastructure with AWS Glue, Redshift, and S3, replacing legacy ETL tools. We need a hands-on ETL Developer to build and maintain scalable pipelines that power analytics and business decisions. You'll work closely with Data Engineering and BI teams to ensure clean, efficient, and well-documented data flows, from SQL Server (RDS) to their Redshift data warehouse. This role is critical in eliminating manual processes and enabling self-service data access If you are independent, a great communicator, a problem solver, and have a strong attention to detail, this is a great fit for you! Our jobs are fully remote; as long as you have the skills and can get the work done well, you can work anywhere in the listed countries you want.Here are some of the exciting day-to-day challenges you will face in this role: Develop and automate ETL workflows using AWS Glue (Python/PySpark) to ingest, transform, and load data into Redshift and S3. Monitor and troubleshoot pipelines, ensuring data accuracy and SLA adherence. Optimize S3 storage (partitioning, lifecycle policies) for cost-effective data lake management. Collaborate on data modeling (star schema, dimensional modeling) for analytics-ready datasets. Document data flows, ERDs, and lineage for clarity and governance. Profile and validate data to catch issues early and maintain trust in reporting. Support BI teams by resolving data discrepancies and improving pipeline efficiency Conduct ad hoc analysis and exploratory data work as needed. Contribute to the documentation of system specifications, testing procedures, and operational support materials. Participate in code reviews and continuous improvement of development standards. Provide production support and assist with troubleshooting and resolving data issues. You will shine if you have: Bachelor's degree in Computer Science or a related field, or equivalent work experience. 3+ years of related work experience as an ETL Developer, with AWS cloud experience (Glue, Redshift, S3). Strong SQL & Python (PySpark preferred). Experience building batch ETL pipelines (not just drag-and-drop tools). Knowledge of data warehousing (ODS, dimensional modeling, slowly changing dimensions). Ability to troubleshoot pipeline failures and optimize performance/cost. Clear communicator who can explain technical details to non-engineers. Excellent problem-solving and analytical skills. Strong organizational skills and attention to detail. Here are some of the perks we offer you: Salary in USD Long-term Flexible schedule (within US Time zones) 100% Remote Ready to learn more? Apply below!

Palco is a visionary company pioneering an emerging health-care movement that empowers people with disabilities and those aging to live independent and quality lives. Made possible by our amazing team, Palco provides technology and financial services to aid individuals and their families to thrive in their home and communities. Partnered with government agencies and fortune 500 managed care organizations across the country, we are dedicated to creating exceptional outcomes for our clients and the millions of people that count on them. We are a highly organized company that offers a solid work/life balance, autonomy, generous paid time off, bonus potential, and career advancement opportunities. Our staff make long-lasting impact on the lives of people every day. We are seeking an ETL Developer II to join our growing team. This is a fully remote, work-from-home position. The ideal candidate will be responsible for creating, enhancing, and administering ETL processes, ensuring seamless data integration across internal systems, and supporting various teams with reliable data solutions. This role is integral to the development of data-centric tools and processes and will work closely with a small, remote team. Duties and Responsibilities Design, create, and enhance ETL processes to support internal teams and business functions. Administer and maintain the ETL ecosystem, ensuring data accuracy, integrity, and performance. Collaborate with key stakeholders to understand application business logic and deliver effective integration solutions. Generate reports and queries from various databases to support data-driven decision-making or business processes. Continuously improve and automate data workflows, identifying opportunities to enhance efficiency and reliability. Work with APIs and integration tools to facilitate data exchange between systems. Proactively identify and resolve issues in data pipelines, ensuring smooth operations. Requirements 3+ years of experience working with relational databases and SQL. Bachelor's degree in Computer Science, Information Systems, or related field. 3+ years of experience with ETL tools (e.g., Talend, SSIS, Informatica, or similar). 3+ years of experience using Excel for data manipulation and reporting. Experience with API testing tools (e.g., Postman) and working with APIs for integrations. Familiarity with BI and reporting tools (e.g., Power BI, Tableau, or similar). Strong troubleshooting, problem-solving, and critical thinking skills. Ability to apply smart, effective solutions to unique data challenges. Excellent written and verbal communication skills, with the ability to explain technical concepts to non-technical stakeholders. Preferred Qualifications Familiarity with data governance and data quality best practices. Knowledge of cloud platforms and services (e.g., AWS, Azure, or Google Cloud). Join Us This position is remote/work-from-home role. Enjoy the convenience of working from home and maximize your time by unplugging at the end of your workday. Company benefits designed for you: Generous Paid time off. Annual bonus potential. Retirement Savings: We will support you as you save for your future. Career Growth Opportunities: We help you thrive, so together, we can grow. We provide opportunities to advance your career with a vast portfolio of businesses and a global footprint. Paid Training: Earn while you learn and continue to grow with access to internal and external learning opportunities. Great Work Environment: We are proud of our company culture of collaboration and the recognition we have received for our diversity efforts. Benefits package: Employer shared Health Insurance cost Paid Time Off Remote work environment Paid holidays When you join Palco, you are engaged in creating the future - both our company's, the people we serve, and your own. We understand that our success is directly related to the success of our team. We strive to create a culture where you can: Bring your authentic self to work. Grow and thrive, both personally and professionally. Make a difference with our clients, in our communities, and with the millions of people we support. Experience work/life balance. Feel value and a greater purpose through the work you do. Palco, Inc. is an Equal Employment Opportunity (EEO) employer and does not discriminate in any employer/employee relations based on race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.

Greetings Everyone Who are we? For the past 20 years, we have powered many Digital Experiences for the Fortune 500. Since 1999, we have grown from a few people to more than 4000 team members across the globe that are engaged in various Digital Modernization. For a brief 1 minute video about us, you can check ***************************** What will you do? What are we looking for? Job Title: Senior ETL Developer - Data Services Team Key Duties • Plays a lead role in the areas of ETL design, data modeling, and ETL development. • Facilitates best practice guidelines around all stages of development. • Provides technical leadership to serve as point of escalation, review, and approval for key issues, significant projects, and decisions. • Able to work with stakeholders, and translate requirements to design and build a solution that will meet Business needs and integrate seamlessly with the EDW. • Gain team and stakeholder approval for all designs, and effort estimates. • Research and analyze current systems, subsystems and interfaces to understand the current or new process flow. • Document work via Functional and Tech Specs. • Develop unit tests, performance tests, and take into account security requirements. • Prepare and participate in design and code reviews. • Analyzes processes for gaps and weaknesses, building future state models and creating the roadmaps and migration plans to get there. • Communicate progress and work using the Agile Methodology. Job-Specific Skills • Required: o 5+ years of experience of with Oracle o 5+ years of experience with Data Warehousing: building relational databases, star schemas o 5+ years of experience with Data Modeling o 4+ years of experience with ODI (Oracle Data Integrator Tool) or Informatica IDMC. o 3+ years of experience with Databricks Lakehouse and/or Delta tables. o 2+ years of experience in the design, implementation, and support of a Kimball method data warehouse on SQL Server or Oracle o Strong SQL reading and writing skills o Business and/or technical background in the areas of Data Integration (ETL), Data Security, and Enterprise Data Warehouse development o Experience in Change Management, Release Management, and Source Code control practices Education • High school diploma or equivalent is required. • A Bachelor of Arts or a Bachelor of Science degree, with a focus in computer science, systems analysis, or a related area, is preferred. Compensation, Benefits and Duration Minimum Compensation: USD 44,000 Maximum Compensation: USD 176,000 Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role. Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees. This position is also available for independent contractors No applications will be considered if received more than 120 days after the date of this post

ETL Developer Clearance Required: Active IRS MBI Clearance Yudrio is seeking a highly skilled ETL Developer with extensive experience in Informatica PowerCenter development and related component technologies (e.g., ETL Designer). The ideal candidate will have a proven track record in building, maintaining, and optimizing ETL processes, stored procedures, functions, and inline SQL. This role requires strong performance tuning skills, familiarity with Agile methodologies, and the ability to work independently across all phases of the Software Development Life Cycle. Key Responsibilities Design, develop, and maintain ETL processes using Informatica PowerCenter and related tools. Create, optimize, and manage stored procedures, functions, and SQL scripts. Perform performance tuning for Informatica sources, mappings, targets, and sessions. Participate in all phases of the SDLC, with emphasis on Agile project environments. Work with Greenplum (PostgreSQL) and/or Oracle SQL/PLSQL for database development and optimization. Monitor, support, and resolve issues for applications leveraging technologies such as Informatica, Greenplum, and Mainframe systems. Provide support during production maintenance windows and participate in on-call rotations as needed. Required Qualifications Active IRS MBI Clearance (required for consideration). 7+ years of experience as a software developer with the specified technologies. 3+ years of experience using Rational Team Concert or equivalent tools. Demonstrated experience with Control-M (specific to ETL development). Hands-on experience with Greenplum or a similar database platform. Professional Skills Strong oral and written communication skills with the ability to engage stakeholders at all organizational and technical levels. Excellent time management skills and the ability to meet deadlines in a fast-paced environment. Proven ability to work effectively in a collaborative, high-performing team environment. Proficiency with Microsoft Office Suite (Word, PowerPoint, Excel, SharePoint).

All SA Technologies requirements are Direct Client Requirements from IT Hiring Managers. We guarantee you the best rate for your skills and performance. Role: Informatica Developer Duration: 12 + months Location : Columbus, Ohio Job Description: ETL specialist will be responsible for: Administer Informatica shared services platform for a large data warehouse environment Maintain and monitor the Informatica platform. Ensuring proper configuration of the Informatica platform and identifying opportunities to tune and optimize the existing platform workload. Participating in the continuous improvement of key deliverables, refinement and additions to the Velocity methodology Review and migrate the code developed by various teams and size the environment accordingly Additional Information All your information will be kept confidential according to EEO guidelines.

Come Find Your Spark at Quartz! The ETL Architect will be responsible for the architecture, design, and implementation of data integration solutions and pipelines for the organization. This position will partner with multiple areas in the Enterprise Data Management team and the business to successfully translate business requirements into efficient and effective ETL implementations. This role will perform functional analysis, determining the appropriate data acquisition and ingestion methods, and design processes to populate various data platform layers. The ETL Architect will work with implementation stakeholders throughout the business to evaluate the state of data and constructs solutions that deliver data to enable analytics reporting capabilities in a reliable manner. Skills this position will utilize on a regular basis: Informatica PowerCenter Expert knowledge of SQL development Python Benefits: Opportunity to work with leading technology in the ever-changing, fast paced healthcare industry. Opportunity to work across the organization interacting with business stakeholders. Starting salary range based upon skills and experience: $107,500 - $134,400 - plus robust benefits package. Responsibilities Architects, designs, enhances, and supports delivery of ETL solutions. Architects and designs data acquisition, ingestion, transformation, and load solutions. Identifies, develops, and documents ETL solution requirements to meet business needs. Facilitates group discussions and joins solution design sessions with technical subject matter experts. Develops, implements, and maintains standards and ETL design procedures. Contributes to the design of the data models, data flows, transformation specifications, and processing schedules. Coordinates ETL solution delivery and supports data analysis and information delivery staff in the design, development, and maintenance of data implementations. Consults and provides direction on ETL architecture and the implementation of ETL solutions. Queries, analyzes, and interprets complex data stored in the systems of record, enterprise data warehouse, and data marts. Ensures work includes necessary audit, HIPAA compliance, and security controls. Data Management Collaborates with infrastructure and platform administrators to establish and maintain scalable and reliable data processing environment for the organization. Identifies and triages data quality and performance issues from the ETL perspective and see them through to resolution. Tests and validates components of the ETL solutions to ensure successful end-to-end delivery. Participates in support rotation. Qualifications Bachelor's degree with 8+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP (Online Transaction Processing) environments, semantic layer modeling experience, and SQL programming experience. OR associate degree with 11+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP environments, semantic layer modeling experience, and SQL programming experience. OR high school equivalence with 14+ years of experience translating business requirements into business intelligence solutions, data visualization, and analytics solution design and development experience in a data warehouse and OLTP environments, semantic layer modeling experience, and SQL programming experience. Expert understanding of ETL concepts and commercially available enterprise data integration platforms (Informatica PowerCenter, Python) Expert knowledge of SQL development Expert knowledge of data warehousing concepts, design principles, associated data management and delivery requirements, and best practices Expert problem solving and analytical skills Ability to understand and communicate data management and integration concepts within IT and to the business and effectively interact with all internal and external parties including vendors and contractors Ability to manage multiple projects simultaneously Ability to work independently, under pressure, and be adaptable to change Inquisitive and seek answers to questions without being asked Hardware and equipment will be provided by the company, but candidates must have access to high-speed, non-satellite Internet to successfully work from home. We offer an excellent benefit and compensation package, opportunity for career advancement and a professional culture built on the foundations of Respect, Responsibility, Resourcefulness and Relationships. To support a safe work environment, all employment offers are contingent upon successful completion of a pre-employment criminal background check. Quartz values and embraces diversity and is proud to be an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, gender identity or expression, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified person with disability. We can recommend jobs specifically for you! Click here to get started.

Job Description Primary Responsibilities: Manages and maintains all productions and non-production Teradata and other Data Warehouse MPP database systems Works with (EDW) Enterprise Data Warehouse team with workload management standards for groups, roles, priorities Lead and mentor Strong presentation and verbal communications skills are essential Must Have: Management / Administration of MPP (Massively Parallel Processing) databases MPPs = Teradata, Snowflake, Greenplum, Netezza or Redshift (Amazon/AWS) Setting up Monitoring alerts for Workflow Management Audit procedures and Database Security LDAP requirements documentation Scripting programming, any language to move the data, like Python or Linux Strong Plus: Teradata Certification Knowledge or Retail Industry ETL experience with tools ODI or Ab Initio

ETL Developer (AB Initio) :: Columbus, Ohio 43219 Skills/Experiences: Looking for an ETL developer with multiyear in depth experience using Abinitio if they have Open Text Dialogue or Quadient GMC Inspire experience that would be a plus but far from required. Candidate should have 4-5 years of experience in Industry. Can should have around 1-2 years of experience with Ab initio. Additional Information All your information will be kept confidential according to EEO guidelines.

USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers. Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services. Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps. USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area - Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness. Informatica Dublin, OH 6+ Months Need GC and USC, GC-EAD Top Three Skills: 1. Informatica Development experience 2. Unix Scripting experience and Teradata experience 3. SQL and/or PL/SQL- there are lots of data connections that require queries, stored procedures, and general reverse engineering experience Job Description: ETL Developer for a mix of build and run work. Will align with the Agility team in DW. Skill set needed: ETL, Informatica, Terra Data, SQL, Ruby and Cucumber Basic ETL development, Informatica, Terra Data, SQL, Ruby and Cucumber with good database knowledge and working experience, "Practitioners of the IT Application Development profession primarily focus on providing high quality, cost effective information technology solutions to business partners by creating new or modifying and/or supporting existing software applications. Associates are expected to design, code, analyze, configure, unit test, and maintain applications. With full competency, devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results. Designs, codes, tests, debugs, and documents those programs. Competent to work at the highest technical level of all phases of applications programming activities." Additional Information If you are interested please share your resume to Preethib@usmsystems(dot)com or can directly call me on ************

Company DescriptionDESCRIPTION: Our client is a leading retailer based in central Ohio with an enterprise initiative to overhaul their data warehouse, business intelligence, and analytic platform. Job Description ETL Developer - Custom Development Full Time Permanent Position in Columbus OH The business driver for this initiative is to enable the enterprise to make effective decisions based on data, thus reducing risk for the business and enabling agility in the business. This multi-year program involves a new architecture, tools, and processes to build and implement this environment. It also involves conversion from the existing platform. The manager for the team is seeking a strong developer to build ETL programs and processes for the new platform. This role will involve working with architects, business stakeholders, and team members to analyze the design, and do the detail technical design and development for new ETL programs. The architecture and design for the ETL environment is custom development using Korn Shell Scripting (KSH), SQL, and related tools. The data warehouse environment is Teradata. While a high degree of technical expertise is needed, this is not a “heads down” coding position. The successful candidate will have strong interpersonal and communication skills, coupled with five or more years' experience focused on the development of ETL processes. Technical expertise will focus on KSH, SQL, Linux / Unix, and related skills. RESPONSIBILITIES: As part of the ETL team, develop, review, and refine technical design for ETL processes. Learn and support the data model and architecture for the new environment. Analyze and enhance ETL processes to determine data sources and destinations. Develop, test, and implement ETL process for new platform. As required, support for the current data warehouse environment. Work with business and technology stakeholders to understand business requirements and technology needs. Qualifications SKILLS / KNOWLEDGE / EXPERIENCE: Strong written and oral communication skills. Ability to adapt communications for various audiences. The ability to work as a collaborative team member yet be self-managed and directed as needed. Initiative to take action towards objectives when faced with ambiguity. Exceptional skills developing with Korn Shell Scripting, SQL, and related Unix / Linux tools. Strong database experience with Teradata, Oracle, PL/SQL, and relational and multi-dimensional designs. Typically, four to seven years' experience working in a data warehouse / BI environment, specifically in custom development of ETL processes. Proven ability to build ETL packages / scripts from scratch. Strong testing skills. Understanding of data warehouse architectures and designs including Star Schemas, Snowflake Schemas, Slowly Changing Dimensions, and Aggregation Techniques. Data cleansing, data modeling, and other data related experience. Performance tuning and optimization experience. Additional experience in Oracle OD / RA, SSIS, MicroStrategy BI, and Message Based integration is a plus. Additional Information All your information will be kept confidential according to EEO guidelines.

Job Description Scope of Work/Job Characteristics The Data Architects, under the working job title of Extract, Transform, Load (ETL) Architects, will serve as the principal line of communication for the project team. The ETL Architects will drive the development of data integration pipelines, enabling efficient, reliable access to critical data within the Correction Information Management System (CIMS) Data Warehouse/Data Lake on Azure. They will work with Azure Data Factory (ADF), Azure Databricks, Azure Synapse, Power BI, and Azure Purview. The ETL Architects will be at the forefront of transforming complex data into actionable insights. The ETL Architects will be responsible for ensuring data integrity, security, and performance, all while meeting mission-critical needs. The specific duties and responsibilities of this position are as follows: ETL Pipeline Design and Development: Lead the design and development of high-performing ETL processes to integrate and transform data across disparate sources; Deliver efficient, reliable pipelines that meet business needs and maintain the highest standards of security; and Utilize ADF to automate and streamline data workflows, ensuring smooth transitions from source to target. Data Integration and Transformation: Build and manage complex ETL workflows that extract, transform, and load data for downstream analytics and reporting, ensuring data is accurate, timely, and secure; and Take ownership of data quality and validation, creating resilient ETL processes that ensure only trusted data reaches its destination. Cloud Platform Expertise: Leverage the full power of the Azure ecosystem ADF, Databricks, Synapse, and Purviewto manage and process high volumes of structured and unstructured data, delivering solutions that are scalable and performance-optimized; and Integrate large datasets into Azure Synapse Analytics, enabling analytics teams to deliver data-driven insights that support the Departments mission. Performance Optimization: Continuously optimize ETL jobs to minimize latency and maximize throughput; and Ensure the architecture supports fast, reliable data access for end-users and systems, meeting stringent performance metrics. Security and Compliance: Embed security and compliance best practices in every step of the ETL process;. Protect sensitive data by adhering to industry standards and ensuring compliance with the Departments data governance policies; and Use Azure Purview to enforce data governance, track data lineage, and ensure that data handling meets the highest standards of integrity. Collaboration and Stakeholder Engagement: Partner with cross-functional teams (e.g., data engineers, analysts, business stakeholders, and security experts) to design and implement ETL solutions that meet the Departments evolving needs; and Act as a technical leader and mentor, helping guide junior team members and providing expert guidance on data processing and transformation best practices. Documentation and Best Practices: Develop and maintain clear, detailed documentation for ETL processes, ensuring the team can consistently deliver high-quality, reliable solutions; and Establish and enforce best practices for data handling, ETL development, and security, driving a culture of excellence and accountability. Required Qualifications A bachelors degree from an accredited college or university in Computer Science, Information Systems, or a related field is required. Alternatively, equivalent work experience, including experience in Service-Oriented Architecture (SOA) and Microsoft Azure Cloud Solutions, can be substituted for the educational requirement on a year-for-year basis, when applicable. The Department requires the following experience, skills, and knowledge for this position: Seven (7) or more years of experience in ETL development and data engineering; Three (3) or more years of hands-on experience working with ADF, Azure Cloud, Azure Databricks, Azure Synapse Analytics, and Azure Purview; Proven track record of building and optimizing large-scale ETL pipelines for high-performance, high-availability environments; Extensive expertise in Spark, Python, and/or Scala for large-scale data transformations; Strong Structured Query Language (SQL) proficiency and experience working with complex data structures; In-depth knowledge of data governance, security protocols, and role-based access control (RBAC) within the Azure ecosystem; and Ability to design ETL processes that are resilient, efficient, and fully compliant with regulatory standards. Preferred Qualifications The Department prefers the Candidates to have the following experience, skills, and/or knowledge for this position: Possession of a Microsoft Office Certification as an Azure Data Engineer Associate, Azure Solutions Architect Expert, and Azure Fundamentals; and Azure Databricks Certification as a Data Engineer Associate. This is a remote position.

Must To Have Hands on knowledge in python ETL Testing Good to have b. APIs testing c. experience with test automation d. AWS s3 GxP is not needed/optional. DB testing is one of the key stills mentioned. Resource need not be in person - this is a remote role. So anyone who can provide 100% EST overlap is good.

E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website ****************** Job Description Title : ETL Architect Location : Columbus, OH Type : Fulltime Permanent Work Status : US Citizen / GC / EAD (GC) Required Skills: • Responsible for Architecture, Design and Implementation of Data Integration/ETL, Data Quality, Metadata Management and Data Migration solutions using Informatica tools • Execute engagements as Data Integration-ETL Architect and define Solution Strategy, Architecture, Design and Implementation approach • Expertise in implementing Data Integration-ETL solutions which include components such as ETL, Data Migration, Replication, Consolidation, Data Quality, Metadata Management etc. using Informatica products (e.g. Power Center, Power Exchange, IDQ, Metadata Manager) • Responsible for Detailed ETL design, Data Mapping, Transformation Rules, Interfaces, Database schema, Scheduling, Performance Tuning, etc • Lead a team of designers/developers and guide them throughout the implementation life cycle and perform Code review • Engage client Architects, SMEs and other stakeholders throughout Architecture, Design and implementation lifecycle and recommend effective solutions • experience in multiple Databases such as Oracle, DB2, SQL Server, Mainframe, etc • Experience in Industry models such as IIW, IAA, ACORD, HL7, etc. and Insurance products (e.g. Guidewire) will be plus Additional Information All your information will be kept confidential according to EEO guidelines.

Prepares, defines, structures, develops, implements, and maintains database objects. Analyze query performance, identify bottlenecks, and implement optimization techniques. Defines and implements interfaces to ensure that various applications and user-installed or vendor-developed systems interact with the required database systems. Creates database structures, writing and testing SQL queries, and optimizing database performance. Plans and develops test data to validate new or modified database applications. Work with business analysts, and other stakeholders to understand requirements and integrate database solutions. Build and implement database systems that meet specific business requirements ensuring data integrity and security, as well as troubleshooting and resolving database issues. Design and implement ETL pipelines to integrate data from various sources using SSIS. Responsible for various SQL jobs. Skills Required Strong understanding of SQL and DBMS like MySQL, PostgreSQL, or Oracle. Ability to design and model relational databases effectively. Skills in writing and optimizing SQL queries for performance. Ability to troubleshoot and resolve database-related issues. Ability to communicate technical information clearly and concisely to both technical and non-technical audiences. Ability to collaborate effectively with other developers and stakeholders. Strong ETL experience specifically with SSIS. Skills Preferred Azure experience is a plus .Net experience is a plus GITHub experience is a plus Experience Required 2 years of progressively responsible programming experience or an equivalent combination of training and experience. Education Required Bachelor`s degree in Information Technology or Computer Science or equivalent experience

Remote Cognos TMI Developer needs 3 years, typically 5+, years of system analysis, system administration and programming experience required Remote Cognos TMI Developer requires: Bachelors degree in Computer Science or related field or equivalent years of experience is required. Equivalent years of experience are determined as one year of technical experience for every year of college requested. Minimum of 3 years, typically 5+, years of system analysis, system administration and programming experience required Experience with Cognos Analytics, IBM Planning Analytics Local, IBM Planning Analytics Workspace and TM1 required Experience with Microsoft Windows Server and Red Hat Enterprise Linux RHEL required Experience with Red Hat OpenShift Container Platform and Podman preferred Experience with SQL, Microsoft SQL Server Reporting Services SSRS and Microsoft Power BI preferred Report writing, cube building and analysis experience with Cognos is a plus Experience in the health insurance industry preferred Knowledge of information technology concepts, application development methodology, terminology and standards. Demonstrated ability to lead, organize and prioritize multiple assignments and associated resources. Demonstrated ability to interpret and translate technical and/or complex concepts into information meaningful to team members and/or business personnel Excellent communication skills in technical and non-technical forms are required Proven analysis, design, and coding skills, and demonstrated success in leading medium to complex technology-based efforts. Remote Cognos TMI Developer duties: Formulates and defines system scope and objectives through research and fact-finding to design, develop, modify, or integrate complex information systems Devises or modifies application systems and procedures to optimize functional requirements including capacity, operating time, response time, and form of desired results. Designs, codes, tests, debugs, and documents programs, subroutines, and scripts. May serve one or more project team roles, such as project lead, business systems analyst, or technical lead, for small to medium efforts or manage phases of medium to large efforts. Competent to work at the highest phases of applications systems analysis and programming activities Enhances the design of current systems to improve system capabilities to meet the changing needs of the business. Works with business users or business systems analysts to understand requirements and translate them into technical specifications Develops and implements program/system test plans. Devises data verification methods and standard system procedures. Maintains technical skill set for software languages, databases, platforms, operating systems, utilities and networks needed to support work assignments programming personnel. Regularly provides guidance and training to less-experienced analysts/programmers.

Job Description Looking for Cognos Developer Duration: Long Term Rate: DOE Phone interview first, then in person round Must have Informatica experience developing, maintaining, and supporting extract, transform, and load data flows.Also, excellent SQL skills. These resources will be working on our conversion of Business Objects to Cognos, so experience with BO is a bonus. 3+ years experience designing and developing using Cognos (Cognos FM Models, reports, dashboards, data modules, data sets, etc.). 5+ years any BI Development Development Experience with Cognos Analytics a must Work with external and internal partners at both the business and technical level to define requirements and identify solutions Analysis, diagnosis, and resolution of technical issues relating to development of reporting solutions Ability to work independently and on cross functional teams Communicate with business users and other IT groups at a technical and functional level Develop appropriate documentation both technical and procedural Participate in code reviews Must have excellent communication skills, both verbal and written This position will be joining an existing agile team made up with experienced developers. Therefore, a slightly junior to mid-level resource would be acceptable. Skills needed for this position are: Report Development Technical skills: Cognos, SQL Understanding of Cognos solution development including reports, dashboards, framework, data module, etc. Familiarity with Cognos 11, is highly valued Ability to understand Business Objects reports for the purposes of completing analysis for conversion to Cognos -- Best Regards Vijay Intuites LLC 4640 Valais Ct, Ste 101A, Johns Creek, GA 30022 Direct: ************ |Fax: ************ Email: ****************** | (Best way to reach me is via Email)

IDEALFORCE has a CONTRACT position available immediately for a Cognos Developer(Programmer 4/PR4) to join our customer in Columbus, OH. This is an ONSITE position. Please find below additional details about this job. Client prefers to do onsite interview. Job Description Client is implementing a new claims, policy and billing system. This new implementation is shifting data warehouse and reporting infrastructure from DB2/Hyperion to Oracle/Cognos. The nature of our data is also changing, as data elements are changing purpose and semantics as part of the transition. Client's new system will have a transaction data store (TDS), operational data store (ODS) and a newly designed Oracle enterprise data warehouse. The Cognos developer will be primarily involved in developing reports using Cognos Report Studio, and performing Unit testing. They will collaborate with framework modelers, data analysts, business analysts, testing specialists, and business customers to create business reports that are accurate, reliable, attractive, timely, and relevant. Day-in-the-Life: During a given day, this position will be expected to • Design and develop complex Report Studio objects (e.g. Active Reports, complex conditional formatting, and complex hierarchical development within list frames) based upon report specifications -Unit test developed reports and verify results against specifications • Serve as a reporting expert as needed during user and systems testing • Identify and document any inconsistencies between data model and report specifications • Identify and document any software issues encountered • Document functional specifications, technical specifications and unit testing requirements as assigned • Use Cognos and Oracle software and tools to perform required tasks • Perform knowledge transfer to Client staff. Qualifications • 8 Years of experience with SQL programming against an Oracle RDBMS on data warehouse or business intelligence projects. • 7 Years of experience with business intelligence tools including IBM Cognos • 5 Years of experience with the development and support using dimensional star schema based data structures including fact tables (commonly referred to as Kimball) • 4 Years of experience designing and developing Cognos (version 8.2 and above) reports using Report Studio, Analysis Studio and Active reports Interview Process: 1st Round Phone Interview 2nd Round Face to Face or Skype Additional Information Additional Information : - "All your information will be kept confidential according to EEO guidelines". - All candidates who are authorized to work in US are encouraged to apply. - Candidates must clear the Background check prior to commencing the assignment. THIRD PARTY CANDIDATES: Email your candidate/s resume to joseph dot shelton at idealforce.com along with the following details: Rate, Current location and Availability. Disclaimer : The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.